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

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?
--
David Biddulph

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

=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.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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?
--
David Biddulph

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

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

If this post helps click Yes
---------------
Jacob Skaria


"osaka78" wrote:

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

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


"osaka78" wrote:

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

Look at chip Pearsons explanation of the DATEDIF function here

http://www.cpearson.com/excel/datedif.aspx

M




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