Google Sheets Date Difference Formulas
Exact spreadsheet formulas for counting calendar and working days in Google Sheets.
MM/DD/YYYY
MM/DD/YYYY
Resulting Duration
43 days
1 month, 13 days · 6 weeks, 1 day
31 weekdays 12 weekend days
Weeks
6w 1d
Hours
1,032
Minutes
61,920
Seconds
3,715,200
Google Sheets Date Difference Formulas
Google Sheets supports the same core date functions as Excel:
- Calendar Days:
=DAYS(B2, A2)or=MINUS(B2, A2) - Working Days:
=NETWORKDAYS(A2, B2, Holidays!A2:A12) - Years, Months, Days:
=DATEDIF(A2, B2, "Y")