Skip to main content
rachelle_b
Known Participant
April 17, 2019
Question

Calculation script needed for the number of months between a start date and end date.

  • April 17, 2019
  • 3 replies
  • 1415 views

The date will be formatted as mm dd yyyy. Thanks for your help and time.

This topic has been closed for replies.

3 replies

JR Boulay
Community Expert
Community Expert
April 17, 2019
Acrobate du PDF, InDesigner et Photoshopographe
rachelle_b
Known Participant
April 18, 2019

Thanks JR.

rachelle_b
Known Participant
April 18, 2019

Thank you!

rachelle_b
Known Participant
April 17, 2019

Just to clarify, the result should have at least 2 decimals. Here is the existing Excel calculation:

=DATEDIF(STARTDATE+2-DAY(STARTDATE+1),ENDDATE,"m")-(DAY(STARTDATE +1)-1)/DAY(EOMONTH(STARTDATE +1,0))+DAY(ENDDATE)/DAY(EOMONTH(ENDDATE,0))+0.03