Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Number and Text Filters Examples in Excel
  • Managing Conditional Formatting Rules in Excel
  • How to create dynamic reference table name in Excel
  • How to count table rows in Excel
  • Add Outline to Data in Excel

References

  • Vlookup Examples in Excel
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • Lookup entire row in Excel
  • How to use Excel ROWS Function
  • Multi-criteria lookup and transpose in Excel

Data Validations

  • Excel Data validation no punctuation
  • Prevent invalid data entering in specific cells
  • Excel Data validation allow weekday only
  • Excel Data validation date in specific year
  • Data validation must not exist in list

How to calculate working days left in month in Excel

by

To calculate the number of workdays remaining in a month, you can use the NETWORKDAYS function. NETWORKDAYS automatically excludes weekends, and it can optionally exclude a custom list of holidays as well.

Formula

=NETWORKDAYS(date,EOMONTH(date,0),holidays)

Explanation

In the example shown, the formula in C5 is:

=NETWORKDAYS(B5,EOMONTH(B5,0),E5:E14)

Were B5 contains a current date, and the range E5:E14 contains dates that are holidays.

Note: NETWORKDAYS includes both the start and end dates in the calculation if they are workdays.

How this formula works

NETWORKDAYS is a built in function accepts a start date, end date, and (optionally) a range that contains holiday dates.

In this case, the start date is Jan 10, 2018, provided as cell B5. The end date is calculated using the EOMONTH function with an offset of zero, which returns the last day of the month of the date given. A list of holidays is provided as the range E5:E14.

The EOMONTH function resolves to Jan 31, 2018, and the number of working days between Jan 10 and Jan 31 (inclusive) is 16. One of those working days (Jan 15) is listed as a holiday, so NETWORKDAYS returns a final result of 15.

Custom workdays / weekends

To work with custom weekends (i.e. weekends are Sunday and Monday, etc.) switch to the more robust NETWORKDAYS.INTL function, which allows control over which days of the week are considered workdays.

Working days remaining this month

To return the working days that remain in the current month, the formula can be adapted with the TODAY function as follows:

=NETWORKDAYS(TODAY(),EOMONTH(TODAY(),0),holidays)

Post navigation

Previous Post:

DECIMAL function: Description, Usage, Syntax, Examples and Explanation

Next Post:

AVERAGE function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Nested IF function example in Excel
  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel FALSE Function
  • How to use Excel XOR Function
  • How to use IFS function in Excel

Date Time

  • Add months to date in Excel
  • Get days, months, and years between dates in Excel
  • How to calculate most recent day of week in Excel
  • How to calculate next day of week in Excel
  • Convert decimal hours to Excel time

Grouping

  • How to randomly assign data to groups in Excel
  • Group arbitrary text values in Excel
  • Running count group by n size in Excel
  • Map text to numbers in Excel
  • Calculate conditional mode with criteria in Excel

General

  • How to calculate percentage discount in Excel
  • Basic numeric sort formula in Excel
  • Find, Select, Replace and Go To Special in Excel
  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • Hide and Unhide Columns or Rows in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning