Number of business days that have passed in the current year

You can return the number of business days that have passed in the current year by using


 A
1=TODAY() = Monday 01 April 2024
2=NOW() = Monday 01 April 2024 19:44:48

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


Built-in Functions

TODAY - The date serial number representing today's date.
NOW - The date 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 month
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


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