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.

Cell "A1" displays the current date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
Cell "A3" displays the number of business days left in the month.
Cell "A4" displays the number of business days left in January after Monday 20th.
Cell "A5" displays the number of business days left in January after Monday 27th.

	A
1	=TODAY() = Sunday 01 May 2022
2	=NOW() = Sunday 01 May 2022 18:37:54
3	=NETWORKDAYS.INTL(A1,EOMONTH(A1,0)) = 22
4	=NETWORKDAYS.INTL("20/01/2020",EOMONTH("20/01/2020",0)) = 10
5	=NETWORKDAYS.INTL("27/01/2020",EOMONTH("27/01/2020",0)) = 5

Built-in Functions

TODAY - The serial number representing today's date.
NOW - The serial number of the current system date and time.
EOMONTH - The 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