What Excel formula caluclates number of months between two dates?
 

I want to calculate the number of months between two dates that show in the
format, 11-Jan-07.
HELP Please!

What Excel formula caluclates number of months between two dates?
 

This reply is adopted from Chips' page - see
http://www.cpearson.com/excel/datedif.htm

=DATEDIF(Date1,Date2,"m") where

Date1 is the first date, in standard Excel serial-date format.
Date2 is the second date, in standard Excel serial-date format.




best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"kk" wrote in message
...
I want to calculate the number of months between two dates that show in the
format, 11-Jan-07.
HELP Please!

What Excel formula caluclates number of months between two dates?
 

Chip Pearson has some very nice notes:
http://www.cpearson.com/excel/datedif.htm



kk wrote:

I want to calculate the number of months between two dates that show in the
format, 11-Jan-07.
HELP Please!

--

Dave Peterson

What Excel formula caluclates number of months between two dat
 

Thank you! That works perfectly...one other problem. I want it to stop
rounding the number up or down. I want it to be like this for example:
My 2 dates are 27-Nov-06 19-Nov-08 = 23.78 this is a result from
another system we have. But I'm creating a spreadsheet that we will use
instead so I need it to automatically calculate without rounding.
Thanks!


"Bernard Liengme" wrote:

This reply is adopted from Chips' page - see
http://www.cpearson.com/excel/datedif.htm

=DATEDIF(Date1,Date2,"m") where

Date1 is the first date, in standard Excel serial-date format.
Date2 is the second date, in standard Excel serial-date format.




best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"kk" wrote in message
...
I want to calculate the number of months between two dates that show in the
format, 11-Jan-07.
HELP Please!

What Excel formula caluclates number of months between two dat
 

Thank you! That works perfectly...one other problem. I want it to stop
rounding the number up or down. I want it to be like this for example:
My 2 dates are 27-Nov-06 19-Nov-08 = 23.78 this is a result from
another system we have. But I'm creating a spreadsheet that we will use
instead so I need it to automatically calculate without rounding.

DATEDIF will not calculate fractions of a month... whole number of months
only. If you think about it, though, 0.78 months is a meaningless measure
because the fraction will depend on the number of days and which months are
spanned by them (45 days across February would produce a different fraction
part of a month than 45 days across July). Besides, what is it 0.78 of? That
0.78 would represent 24.18 days if applied to January, but only 21.84 days
if applied to February.

Rick