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.
|
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
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top