Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculating Dates in Terms of Months
I am trying to find a function that will allow me to calculate the difference
between two dates. I want the answer to be shown in months only, therefore I would need any additional days to be converted to a decimal. I tried to the datedif function, but it does not recognize that the time span between months may cross over multiple years. For example I have the following: Start Date: 04/15/02 End Date: 06/28/03 The number of whole months in between is 14, however their are also additional days in between and I am looking to convert those to a decimal. I know the difference in months |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
months between 2 dates!!! | Excel Discussion (Misc queries) | |||
How do I take a column of dates and add six months? | Excel Worksheet Functions | |||
Calculate number of months between 2 dates | New Users to Excel | |||
Need More Help on Dates to Months | Excel Worksheet Functions | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) |