Solved

# of months in between two dates

  • 28 March 2024
  • 2 replies
  • 75 views

Userlevel 3
Badge +6
  • Newly Minted Pigmenteer
  • 21 replies

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! 

 

icon

Best answer by Issam Moalla 29 March 2024, 02:06

View original

2 replies

Userlevel 5
Badge +9

Hi @Yaejis ,

You could actually use the MONTHDIF function.

Issam

Userlevel 3
Badge +6

Thanks!

Reply