Skip to main content
Solved

# of months in between two dates

  • March 28, 2024
  • 2 replies
  • 418 views

Forum|alt.badge.img+8

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! 

 

Best answer by Issam Moalla

Hi @Yaejis ,

You could actually use the MONTHDIF function.

Issam

2 replies

Issam Moalla
Employee
Forum|alt.badge.img+11
  • Employee
  • Answer
  • March 29, 2024

Hi @Yaejis ,

You could actually use the MONTHDIF function.

Issam


Forum|alt.badge.img+8
  • Author
  • Master Author
  • April 2, 2024

Thanks!