Time and Date Duration Calculate duration with both date and time included. In each date we need to add five years. A1 100.
When you have a valid date in Excel you and just add days directly.
The subtraction formula in cell A6 makes use of these numbers to find the number of days between the two dates 43405 - 42292 1113. Duration Between Two Dates Calculates number of days. If you need to add or subtract business days workdays to a date so that you can calculate a date in the future or past that skips weekends and holidays you can use the WORKDAY function. DATE YEAR TODAY MONTH F3DAY F3 Next we need to know if that date has already passed and you can compare that result to TODAY to find out.