Everyday math & dates
Date Calculator
Use the first box to move a date by any mix of years, months, weeks and days. Use the second to count working days, such as a 10-business-day deadline.
Add or subtract time
Your result will appear here.
Add business days
Your result will appear here.
How it's calculated
Years and months are added first. If the new month is shorter, the date moves to its last day, so January 31 plus one month is February 28 (or 29). Weeks and days are added after that.
Business days skip Saturdays and Sundays but not public holidays.
How to do it in Excel
=A2+90- 90 days after the date in A2.
=EDATE(A2, 3)- Three months later. Use a negative number to go back.
=WORKDAY(A2, 10)- Ten business days later. Add a holiday range as a third argument.