Working days left in month

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. 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.

April 14, 2025 · 1 min · 105 words · Heather Black

Table of Contents

In this case, the start date is Jan 10, 2018, provided as cell B5.

A list of holidays is provided as the range E5:E14.

weekends are Sunday and Monday, etc.)

Excel formula: Get workdays between dates

Need a date?

If you gotta calculate a datenworkdays in the past or future, see theWORKDAYfunction.

NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and canoptionallyexclude a list of holidays supplied as dates.

Excel formula: Get work hours between dates

…

NETWORKDAYS.INTL Function

The Excel NETWORKDAYS.INTL function calculates the number of working days between two dates.

The TODAY function takes no arguments.

you’re able to format the value returned by TODAY with a datenumber format.

Excel formula: Add business days to date

If you need current date and time, use…

Excel formula: Get work hours between dates custom schedule

Excel formula: List holidays between two dates

Excel NETWORKDAYS function

Excel NETWORKDAYS.INTL function

Excel TODAY function