Calculating duration between two months

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi,

I'm trying to calculate duration between two months
dates. For example, Feb 04 less Nov 03 = 3 (ie. Nov +
Dec + Jan). I have my data in dd/mm/yyyy format for both
variables.

Anyone able to help?

Thanks
J
 
One way:

If the dates are 31 January 2004 and 1 March 2004 should the answer be 1
month (e.g., 30 days) or 3 months (e.g., Jan + Feb + Mar)?

If the former:

=DATEDIF(A1,B1,"m")

the latter:

=DATEDIF(DATE(YEAR(A1),MONTH(A1),1),DATE(YEAR(B1),MONTH(B1)+2,0),"m")
 
Back
Top