weekends Archives - Sheets Help

NETWORKDAYS.INTL Function – Google Sheets

August 12, 2023November 24, 2022 Adam Steinfurth

NETWORKDAYS.INTL calculates the number of working days between two dates. The function excludes weekends (which may or may not be Saturday and Sunday) and can optionally exclude holidays. If your weekends are Saturday and Sunday, consider using the simpler NETWORKDAYS function. ⚠️ The start_date and end_date are included in the count of days. Syntax =NETWORKDAYS.INTL(start_date,end_date,[weekend day(s)],[holiday(s)]) start_date The date at … Read more

TIME Function – Google Sheets

May 8, 2023October 6, 2022 Adam Steinfurth

The TIME function takes three numbers and converts them to time with hours, minutes, and seconds.

WORKDAY.INTL Function – Google Sheets

October 27, 2022May 29, 2022 Adam Steinfurth

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