Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm using this function to calculate date difference, but just stumbled upon
something that's making me think it's wrong. Here it is: =DATEDIF(B3,C3,"y") & " years, " & DATEDIF(B3,C3,"ym") & " months, " & DATEDIF(B3,C3,"md") & " days" It seemed to work fine until I entered the same date into the two cells, and what returned was: 0 years, 0 months, 0 days. This seems odd to me. Shouldn't that be 0 years, 0 months, 1 days. Why doesn't the function count the "zero date" as one? How should I modify it so I get an accurate result? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Difference between date and times | Excel Discussion (Misc queries) | |||
Mileage Claim Formula | New Users to Excel | |||
IF and Date Functions | Excel Worksheet Functions | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Difference of date | New Users to Excel |