B
butterscotch
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???
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???