Number of business days in a particular month

You can return the number of business days in a particular month by using


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".

 A
1=TODAY() = Sunday 01 May 2022
2=NOW() = Sunday 01 May 2022 18:37:54

Built-in Functions

TODAY - The serial number representing today's date.
NOW - The serial number of the current system date and time.


Related Formulas

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


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