Work out working days between dates instantly with clear inputs, formula shown and shareable results.
Working days count Monday to Friday only, so the answer depends on which weekday the range starts on rather than just its length. From 5 January to 31 March 2026 is 85 calendar days, of which 61 are working days and 24 fall at weekends. The end date is treated as exclusive, matching payroll and project convention.
Working days
count each day in the range whose weekday is Monday to Friday
Weekend days
weekend = calendar days - working days
No, the range is treated as exclusive of the end date, which is the convention in payroll and project scheduling.
They are not deducted here. Use the business days calculator with a holiday count for that.