Calculate calendar days and working days between two dates, with matching Excel formulas.
Select the first date.
Select the second date.
Calendar Days
—
=B1-A1
Working Days (Mon–Fri)
—
=NETWORKDAYS(A1,B1)
Weekend Days
—
Calendar Days - Working Days
Full Weeks
—
=(B1-A1)/7
Excel tip
To exclude holidays in Excel, use
=NETWORKDAYS(A1,B1,HolidaysRange).
Working days are Monday through Friday. Public holidays are not excluded by this calculator.