I'm trying to calculate 30/360 (US) date differences, but I'm confused by the differences between calculating dates in one order vs the other.
When I calculated the difference between date1=2/29/2016 and date2=3/1/16 in Excel (using Days360(date1,date2)), I get one day difference. When I reverse the dates and calculate then I get -2 days difference instead of -1. Why the discrepancy?
I thought the numbers would be consistent either direction. I read the page here: Day_count_convention
which talks about changing day values, but it doesn't go into detail on how to calculate differences in dates or why calculations are different in reverse.
Another confusing point is that the convention tells you to change the day to 30 if you're end of month in February. However, you can't have Feb 30 with any date software.
What is the proper way of calculating the difference between two dates using 30/360 US?