There will be instances where we may need to know the day of the week, for a given date. In Google Sheets, the WEEKDAY...
How to use the WEEKDAY function in Google Sheets
read more
Spreadsheets articles
How to use the HLOOKUP function in Google Sheets
The HLOOKUP function is perhaps not as famous and widely used as its counterpart, VLOOKUP function. However, the two...
How to use the FILTER function in Google Sheets
The FILTER function in Google Sheets helps you filter and return rows in a range that meet specified criteria. You can...
How to use the EOMONTH function in Google Sheets
The EOMONTH function in Google Sheets stands for “End Of MONTH“, and rightly so. It returns the last calendar date of...
How to use the COUNTA function in Google Sheets
The COUNTA function in Google Sheets is a simple and widely-used function for everyday spreadsheet work. It quickly...
How to use the ADDRESS function in Google Sheets
The ADDRESS Google Sheets function returns a cell’s address in the form of a text. It is noteworthy that the resulting...
How to use the SWITCH function in Google Sheets
This Google Sheets SWITCH evaluates an expression against a set of specific cases. The first case to evaluate as TRUE...
How to use the OFFSET function in Google Sheets
The OFFSET function in Google Sheets references a range of cells that are shifted or displaced from a starting...
How to use the SUMPRODUCT function in Google Sheets
The SUMPRODUCT function in Google Sheets multiplies corresponding items within arrays of equal size and returns the...
English 
Español 
Português do Brasil 
Français