Skip to main content

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: