View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default 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