=days360(date1,date2) is calculating 30 days for February

[eneia]

Hi,

I have just discovered that the formula =days360(date1,date2) is counting 30 days for February, for every date - except for 28th of February:

26/02/2013 to 01/03/2013 = 5 days = wrong
27/02/2013 to 01/03/2013 = 4 days = wrong
28/02/2013 to 01/03/2013 = 1 days = Correct
01/03/2013 to 01/03/2013 = 0 days


Is that really a bug in Excel or am I doing something wrong.

I am using MS Office 2010, i tested it in 2013 - it does the same there, BUT there is a new formula in 2013 - =days(start date;end date) that seems to be working fine

Thank you

[martindwilson]

from ms
The DAYS360 function returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve 30-day months.
so feb is assumed to have 30 days
and you just need to subtract earliest date from last date to get the number of days anyway 25/1/2014-18/1/2014 = 7

[eneia]

Thank you !

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.