Correct the =Days360 formula
When i use the =days360 formula and for example i select the start date as 31Jan2017 and the end date as 28Feb2017 the answer is coming to 28 days which is correct but the whole purpose of the formula is to make every month as if it is 30 days. not sure if I'm doing something wrong. Even if you select the method in the formula as TRUE or FALSE it still gives 28 as the answer.
1 comment

Roy commented
A little more detail: if you give a date like 2March17 for the end date, one for which you completely"pass over" February, it DOES give 30 days for February, then adds 2 more for the time in March for a result of 32. So it is adding 30 for the 28 day month, then the 2 for the two days in March.
So apparently it is not "kicking in" until you reach a date more than one month away from the start date. Then a date in February simply counts actual days until the date, rather than recognizing the user sees it as a different month and expects exactly 30.
Hopefully MS can see the ease of fixing it now!
In the meantime (which... might be forever...) one could force it to the end of the month with EOMONTH(), add 1, and calculate. So any time at all in February would yield the expected 30.