# of months in between two dates

Question

Hi Pigment team,

Is there a way to get difference of the two dates in # of months?

Normally in excel, following is used

DATEDIF(EOMONTH(A date cell,0),EOMONTH(B date cell,0),"M")

For example, the # of months in between 1/31/2017 & 2/29/2016 will be “11”.

Thanks in advance for looking into it!

Page 1 / 1

Hi @Yaejis ,

You could actually use the MONTHDIF function.

Issam

Thanks!

Issam Moalla · Accepted Answer

Hi @Yaejis,You could actually use the MONTHDIF function.Issam

Yaejis · Answer

Thanks!

Sign up