If start and end dates are reversed, DAYS will return a negative number.
Seethis articlefor more details.
The TODAY function takes no arguments.
you could format the value returned by TODAY with a datenumber format.
Get days between dates
To count the number of days between two dates you can use the DAYS function or just subtract the start date from the end date. In the example shown, the formula in D6 is: =C6-B6 The result is the number 365, since there are 365 days between Jan 1, 1999 and Jan 1, 2000. Note: To see the result as a number and not a date, format the result with the General number format.
