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.


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


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