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.


 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

NETWORKDAYS.INTL - The total number of working days between two dates excluding weekends and holidays.
WORKDAY.INTL - The date 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


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