Irregularity in calculating difference between two dates
That's what Days360 does -- it assumes months are 30 days long.
The correct way to determine the number of days between two dates is simple
subtractions:
=a41-a40
--
Regards,
Fred
"Sylvie" wrote in message
...
When using the formula =DAYS360(A40,A41) where A40 and A41 are the same date
it returns the correct answer except when 28 February 2007 is entered in both.
Then the result shows as -2 days! How bizare! Any suggestions?
Regards,
Sylvie
|