Number of business days left in the current month

You can return the number of business days left in the current month by combining 2 functions.
The NETWORKDAYS.INTL function will ignore Saturdays and Sundays by default.

	A
1	=TODAY() = Friday 29 November 2024
2	=NOW() = Friday 29 November 2024 11:44:05
3	=NETWORKDAYS.INTL(A1, EOMONTH(A1, 0)) = 1
4	=NETWORKDAYS.INTL("20/01/2020", EOMONTH("20/01/2020", 0)) = 10
5	=NETWORKDAYS.INTL("27/01/2020", EOMONTH("27/01/2020", 0)) = 5

1 - Displays the current date. Custom format "dddd dd mmmm yyyy".
2 - Displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
3 - Displays the number of business days left in the month.
4 - Displays the number of business days left in January after Monday 20th.
5 - Displays the number of business days left in January after Monday 27th.

Built-in Functions

TODAY - The date serial number representing today's date.
NOW - The date serial number of the current system date and time.
EOMONTH - The date serial number of the last day of a month before or after a date.
NETWORKDAYS.INTL - The total number of working days between two dates excluding weekends and holidays.

Related Formulas

Add business days to a date changing the days of the weekend
Number of business days between 2 dates
Number of business days in a particular month
Number of business days left in the current year
Number of business days that have passed in the current month