How to calculate number of months between 2 dates

Kamya Pamnani

Hi,

I want to calculate number of months or years between two dates. How to use the below formula which we can use in Excel to calculate that:

=DATEDIF(Date column,TODAY(),"M")/12

If the date is 4th Jul 22 then the number of months from today should come to 0.3 and if date is 21 May 2021 then the number of months from today come to 1.3.

Please suggest the formula.

Thanks.

PWNA Sam Harwart

@Kamya Pamnani

Would this work?

=(TODAY() - [Date Column]@row)/30