DAYS360---How come the days do not add up to be 360?
Your formulas, input and results please?
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"butterscotch" wrote in message
...
|I applied the DAYS360 function to each month of 2007, and the result is not
| 30 days for each month. In fact each 31-day month turned out to have an
| output of 30 days, each 30-day month has an output of 29, and Feb has an
| output of 27. It added up to 353 days for the year using each month's output.
| However when I use 1/1/2007 and 12/31/2007 as my start and end date, the
| function indeed gives 360 days. I am very perplexed. Could anyone help,
| please???
|