How to count business days left in the month
✓ Verified in LibreOffice 25.8.7.3 ✓ Verified in Google Sheets (2026-08-30)Working days remaining before month-end — quota pacing, close deadlines.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel (desktop) | =NETWORKDAYS(TODAY(),EOMONTH(TODAY(),0)) | Counts today too (if a weekday). Add a holidays range as NETWORKDAYS' 3rd argument. |
| Google Sheets | =NETWORKDAYS(TODAY(),EOMONTH(TODAY(),0)) | Identical. |
| LibreOffice Calc | =NETWORKDAYS(TODAY(),EOMONTH(TODAY(),0)) | Identical. |
How it works
EOMONTH(TODAY(),0) is the last day of the current month, and NETWORKDAYS counts the weekdays from today through that date inclusive — from Friday July 24, 2026 that's the 24th, 27th–31st: 6 working days (the verification pins the dates; use TODAY() live). Divide remaining target by this number for a required daily run-rate. Exclude today by starting from TODAY()+1.
Verified, not just documented
We ran =NETWORKDAYS(DATE(2026,7,24),DATE(2026,7,31)) in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 6 — exactly the expected result. We then ran the same formulas in Google Sheets, executed 2026-08-30: a formula-only workbook goes into Google Drive, which converts it to a Sheet and recalculates every formula with Google’s own engine, and comes back out as .xlsx carrying the values Google computed. It returned 6 for the worked example, the same value LibreOffice produced. Both engines’ numbers on this page are executed results. The Excel formula follows Microsoft’s official documented syntax — we do not run desktop Excel.
Functions used
NETWORKDAYS · TODAY · EOMONTH — see full Excel, Google Sheets & LibreOffice compatibility for each.
Related recipes
- How to count the working days in a month
- How to get the last day of the previous month
- How to calculate age in years from a birth date
- How to count business days between two dates
- How to get the number of days in a month