Conditionally Count Unique Values in Google Sheets
Three techniques to count unique values based on specified criteria.
function
NETWORKDAYS.INTL Function – Google Sheets
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
NETWORKDAYS Function – Google Sheets
Use the NETWORKDAYS function to calculate the number of working days between two dates.
TIMEVALUE Function – Google Sheets
The TIMEVALUE function converts a time to a decimal value between 0 (inclusive) and 1 (exclusive). The function can convert time stored as a string or a number. Google Sheets works with times in formulas as fractions of a number, not as text strings. This function converts times into their usable form. For example, 12 … Read more
TIME Function – Google Sheets
The TIME function takes three numbers and converts them to time with hours, minutes, and seconds.