Irregularity in calculating difference between two dates

[Guest]

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

 

[Fred Smith]

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

 

[David McRitchie]

Hi Sylvie,
Hint DAYS360 if for a 360 day business year.

To find the difference between two dates you merely
subtract the earlier date from the later (or equal) date.
If you have time your will have to remove the time component
in your calculation.

For more information on Date and Time see
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/datetime.htm