Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtracting Dates
Afternoon.
I am trying to subtract dates on an excel worksheet and find the term between the two. For example (english date format dd/mm/yy) 01/01/05 - 01/01/04 = 365 days or 1 year I would ideally like the output to be years then months then days but anything would do. Is this possible in excel? If not does anyone know of an online calculator that could do this? Thanks Sam |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting Dates
Hi
The easiest answer is to take one from the other: =A3-A2 and format the result as General. Andy. "sam" wrote in message ... Afternoon. I am trying to subtract dates on an excel worksheet and find the term between the two. For example (english date format dd/mm/yy) 01/01/05 - 01/01/04 = 365 days or 1 year I would ideally like the output to be years then months then days but anything would do. Is this possible in excel? If not does anyone know of an online calculator that could do this? Thanks Sam -- sam |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting Dates
there is an undocumented function called datedif() which can be used
see: http://www.cpearson.com/excel/datedif.htm for a description. "sam" wrote: Afternoon. I am trying to subtract dates on an excel worksheet and find the term between the two. For example (english date format dd/mm/yy) 01/01/05 - 01/01/04 = 365 days or 1 year I would ideally like the output to be years then months then days but anything would do. Is this possible in excel? If not does anyone know of an online calculator that could do this? Thanks Sam -- sam |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting Dates
There is a function called Datedif. It takes the format as follows:- DATEDIF(START DATE,END DATE,"[D,M,Y]") where D is quoted in days, M is quoted in months and Y is quoted in Years -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=518192 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtracting dates | Excel Discussion (Misc queries) | |||
Subtracting dates to get hours... but I want to skip weekends | Excel Discussion (Misc queries) | |||
Subtracting dates? | Excel Worksheet Functions | |||
subtracting dates to get a age | Excel Discussion (Misc queries) | |||
Dates Subtracting dates. | Excel Discussion (Misc queries) |