NETWORKDAYS Function – Google Sheets

The NETWORKDAYS function calculates the number of working days between two dates. The function excludes weekends (Saturday and Sunday) and can exclude holidays if you provide a list. If you have weekends other than Saturday and Sunday, use the NETWORKDAYS.INTL function. 💡 The start_date and end_date are included in the count of days. Syntax =NETWORKDAYS(start_date,end_date,[holiday(s)]) … Read more

WORKDAY.INTL Function – Google Sheets

The WORKDAY.INTL function calculates a workday a given number of workdays away from a date. You can optionally specify a list of holidays to exclude from the count and other weekends. If your days, months, and years are in separate cells, use the DATE function to combine them. This function is different from the WORKDAY … Read more