How to deduct the number of months in the date column

[enkenmendoza]

Hi  i would just like to ask If how can I make another column if I have these data. I have a date format in the column (yyyy-M-dd) I would just like to trim it through adding another column:

How to create another column (period column) using the raw field:

Date:                                   Expected output (Period)

2020-02-24                                  01

2020-03-11                                  02

2020-04-10                                  03

Basically my period 1 starts from the month of february, then period 2 is march so on and so forth.

[Qiu · Accepted solution]

@enkenmendoza 

Hope I understand your correctly

[AngelosPachis · Accepted solution]

Hi @enkenmendoza ,

I have added some more dates to check if the formula works even if the month is January, which should return you Period =12

Hope that helps,

Angelos