Convert Text date Range to period

Hi,

 

I need to covert the text field range to a period number, what should be the formula for that?

 

I am getting the text range input as: JAN 2019 - DEC 2019 (in a single text cell)

I need an output as period number. 1 for Jan 2019 in one line item and in the second line item 12 for Dec 2019.

 

Thanks for the help 🙂

Best Answer

Answers