Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of Months and Days between 2 dates? | Excel Worksheet Functions | |||
Calculate number of months between dates | Excel Worksheet Functions | |||
Calculate number of months between 2 dates | New Users to Excel | |||
Calculate number of months between 2 dates | New Users to Excel | |||
Number of months between 2 dates | New Users to Excel |