View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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???