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
e.g. 14/Sep/2000 and 10/Mar/2009 = 101.856 months
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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?
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.
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
(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
1/10/2000 to 28/2/2009 101.000
1/3/2009 to 10/3/2009 10days/30= 0.323
101.856
M
Michelle
Look at chip Pearsons explanation of the DATEDIF function here
http://www.cpearson.com/excel/datedif.aspx
M
http://www.cpearson.com/excel/datedif.aspx
M