Holidays are supplied as a list of dates in E5:E14, the named rangeholidays.

weekends are Sunday and Monday, etc.)

switch to the more powerfulNETWORKDAYS.INTL function, which allows control over which days of the week are considered workdays.

Excel formula: Workdays per month

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

…

NETWORKDAYS.INTL Function

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

The TODAY function takes no arguments.

Excel formula: Get workdays between dates

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

If you need current date and time, use…

Excel formula: Get work hours between dates

Excel formula: Add business days to date

Excel formula: Get work hours between dates custom schedule

Excel formula: List holidays between two dates

Excel NETWORKDAYS function

Excel NETWORKDAYS.INTL function

Excel DATE function

Excel TODAY function