Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hoe would I set up a formula to subtract one date from another to determine
how many months and days have passed? For example: subtract 12/14/2002 from 04/07/2005 and tell me the number of months and days have passed. Thanks |
#2
![]() |
|||
|
|||
![]()
http://www.cpearson.com/excel/datedif.htm
datedif is not documented except in excel 2000 -- Regards, Peo Sjoblom (No private emails please) "Bill R" wrote in message ... Hoe would I set up a formula to subtract one date from another to determine how many months and days have passed? For example: subtract 12/14/2002 from 04/07/2005 and tell me the number of months and days have passed. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtracting dates: 8/31/05-8/1/05? | Excel Discussion (Misc queries) | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
subtracting dates to get a age | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Dates Subtracting dates. | Excel Discussion (Misc queries) |