Back to all tools
Excel Date Calculator
Calculate the difference between dates, add or subtract days, weeks, months, or years. Get Excel formulas for date calculations.
Total Days
30
0
Years
1
Months
4
Weeks
2
Days
Excel Formulas
Days between dates:
=DATEDIF(A1,B1,"D")Working days only:
=NETWORKDAYS(A1,B1)Advertisement
How to Use
- Select the calculation mode: difference between dates or add/subtract from date.
- Enter the dates or values.
- View the result in days, weeks, months, and years.
- Copy the Excel formula to use in your spreadsheet.