DAYS360---How come the days do not add up to be 360?

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

Niek Otten

Your formulas, input and results please?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

butterscotch

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!
 
D

David Biddulph

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.
 
N

Niek Otten

Your end dates are all one day early.

Take the following example:

Start date: 1-1-2008
End date: 1-1-2008

Days360 will return zero because not one day has (completely) passed.

If you change all your end dates to the first day of the next month, you'll get 30 days for each pair of dates, no matter what the
real duaration of that month is. So they'll total up to 360 as well.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


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

butterscotch

You are the best! Thank you David.

David Biddulph said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top