Irregularity in calculating difference between two dates
 

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

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

Irregularity in calculating difference between two dates
 

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
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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