Use DAYS Function to calculate different between two valid dates. In simple words, it will return the gap between a start date and end date.
For example, in 25-Jan-2016 and 30-Jan-2016 there is a difference of 5 days.
In the below example, we have referred the cell A1 as the start date and B1 as the end date and we have 9 days in the result. You can also use subtract operator to get the difference between two dates.
In the below example, I have directly inserted two dates into the function to get the difference between them.
Days function works with other date and time functions to create some dynamic formulas.
To learn more about Excel DAYS Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.