Current and past months calculation

Margherita Falavigna

Hi,

I need some input in order to create a formula that gives a different number according to the date it is referring to and according to the current date.

More specifically, I would want a formula that is able to tell me how many months ago a date was. See example below:

Thanks a lot in advance.

Margherita

Hollie Green

If you have a field that has the actual date in it you can use the below formula

=MONTH(TODAY()) - MONTH([field with actual date]@row)

If you don't you can create a helper column that returns a date in each of the months example

If(Date@row="October",Date(2022,10,1),If(Date@Row="September",Date(2022,9,1) continue for each month until the final one then leave off the if statement for the final month