K
kk
I want to calculate the number of months between two dates that show in the
format, 11-Jan-07.
HELP Please!
format, 11-Jan-07.
HELP Please!
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.
B
Bernard Liengme
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
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
D
Dave Peterson
Chip Pearson has some very nice notes:
http://www.cpearson.com/excel/datedif.htm
http://www.cpearson.com/excel/datedif.htm
K
kk
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!
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!
R
Rick Rothstein \(MVP - VB\)
Thank you! That works perfectly...one other problem. I want it to stop
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
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