Months between two dates

O

osaka78

i want formula to calculate number of month btween two dates
e.g. 14/Sep/2000 and 10/Mar/2009 = 101.856 months
 
D

David Biddulph

Tell us how you define a month, then we might be able to suggest a formula.
There are 24 days beyond the 101 months; how did you convert that to 0.856
months?
 
D

David Biddulph

=DATEDIF(A1,A2,"m")+DATEDIF(A1,A2,"md")/DAY(DATE(YEAR(A2),MONTH(A2),0))
would give 10.857, taking the 28 days in February 2009 (as the 101 months
gets you to 14 Feb 2009) and using that to divide by the 24 odd days.
 
J

Jacob Skaria

=DATEDIF(A1,B1,"m")+(DATEDIF(A1,B1,"md")/30)
(format to general)

If this post helps click Yes
 
O

osaka78

14/9/2000 to 30/9/2000 16 days/30 =0.533
1/10/2000 to 28/2/2009 101.000
1/3/2009 to 10/3/2009 10days/30= 0.323
101.856
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding Date formula 1
weeks in a month 1
Excel Help with dates 2
Find the position of a date 6
Formula for finding Date difference between 2 dates 4
Count days between text dates 8
Rounding UP Months' Difference between 2 dates 1
Calculating Monthly returns based on Dates 4

Top