Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtract two dates
I wud lik to know whtr thr is ne formula for date subtraction, ie., if i gv d
formula for sutracting 2dates, i nd to gt the d/f in mm/dd/yyyy format. i doubt leap yrs and 30/31 days may pose an issue -- Thanx n rgds joe |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtract two dates
If the older date is in A1 and the recent date is in B1, then:
=DATEDIF(A1,B1,"y") & " years, " & DATEDIF(A1,B1,"ym") & " months, " & DATEDIF(A1,B1,"md") & " days" -- Gary's Student "Joe" wrote: I wud lik to know whtr thr is ne formula for date subtraction, ie., if i gv d formula for sutracting 2dates, i nd to gt the d/f in mm/dd/yyyy format. i doubt leap yrs and 30/31 days may pose an issue -- Thanx n rgds joe |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtract two dates
The formula is effective, i tried. But d thing is i didnt understand d logic.
Can u pls xpln how d func works n d appln of y, ym n md in 1st, 2nd n 3rd parenthesis resp. -- Thanx n rgds joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
US dates to UK?? | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Subtract time and dates with restrictions | Excel Worksheet Functions | |||
I want to subtract 2 dates and display the result as months | Excel Worksheet Functions |