You are the best! Thank you David.

"David Biddulph" wrote:

You should have the dates as start 1st Jan end 1st Feb, then start 1st Feb
end 1st March, and so on. You've got a day's gap each month.
--
David Biddulph

"butterscotch" wrote in message
...
Hi Niek,
Here are my inputs and outputs:

Start date End Date Output = DAYS360(Start date, End date)
1/1/2007 1/31/2007 30
2/1/2007 2/28/2007 27
3/1/2007 3/31/2007 30
4/1/2007 4/30/2007 29
5/1/2007 5/31/2007 30
6/1/2007 6/30/2007 29
7/1/2007 7/31/2007 30
8/1/2007 8/31/2007 30
9/1/2007 9/30/2007 29
10/1/2007 10/31/2007 30
11/1/2007 11/30/2007 29
12/1/2007 12/31/2007 30
SUM 353
However:
1/1/2007 12/31/2007 360

Moreover, generating quarterly results
1/1/2007 3/31/2007 90
4/1/2007 6/30/2007 89
7/1/2007 9/30/2007 89
10/1/2007 12/31/2007 90

I am confused....

Thanks!



"Niek Otten" wrote:

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