Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DAYS360 | Excel Worksheet Functions | |||
DAYS360 | Excel Worksheet Functions | |||
=DAYS360 | Excel Discussion (Misc queries) | |||
Days360 problem | Excel Worksheet Functions | |||
DAYS360 | Excel Worksheet Functions |