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() = Thursday 09 July 2020
2=NOW() = Thursday 09 July 2020 12:28:52
3=NETWORKDAYS.INTL(A1,EOMONTH(A1,0)) = 17
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

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top