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

DATEDIF Function – Google Sheets

The DATEDIF function calculates the difference between two days. You can return the difference in days, months, years, or combinations. Whereas the DAYS function will only return days, this function has multiple output options. The input for this function needs to be either surrounded by quotes or a cell reference. If your days, months, and … Read more