Number of days between 2 dates excluding weekends

You can use the NETWORKDAYS.INTL function if you want to return the total number of business days between two dates excluding weekends and public holidays
You can use the WORKDAY.INTL function if you want to return the serial number for a given number of working days before or after a date.


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

NETWORKDAYS.INTL - The total number of working days between two dates excluding weekends and holidays.
WORKDAY.INTL - The serial number that is a given number of working days before or after a date.


Related Formulas

Number of days between 2 dates
Number of mondays between 2 dates
Number of days in a particular month
Number of days in a particular year


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