Author

Valentine Schelstraete

Helping SaaS find their right buyer personas and generate organic traffic to build their user and customer base rapidly. Interested in all things product marketing, providing the best product/service to the right profile, and how to scale your tech business.

Latest posts

How to use the WEEKNUM formula in Google Sheets

In Google Sheets, if you need to know what specific week of the year a date falls on, you can use the WEEKNUM formula to find out. The...

How to use the DATEDIF formula in Google Sheets

In Google Sheets, if we need to know how far two different dates are separated from each other, we can make use of the DATEDIF formula. It...

How to use the ROW formula in Google Sheets

The ROW formula is one of the lookup functions available within Google Sheets. It gives us the row number where the specified cell or a...

How to use the COLUMN formula in Google Sheets

The COLUMN formula is one of the lookup functions available within Google Sheets. It gives us the column number where the specified cell...

How to use the DATE formula in Google Sheets

In spreadsheets, working with dates can be a hassle. Sometimes date formats are not properly recognized, and to use dates in formulas you...

How to use the EDATE formula in Google Sheets

In Google Sheets application, if we need to know the date a specified number of months before or after a given date, the EDATE formula can...

How to use the NETWORKDAYS formula in Google Sheets

In Google Sheets application, if we need to know the number of net working days between two specified dates, the NETWORKDAYS formula can...

How to use the TRANSPOSE Google Sheets formula

In Google Sheets, if you ever need to flip the columns and rows of an array or a data range, TRANSPOSE Google Sheets function is the one...

How to use the ARRAY_CONSTRAIN formula in Google Sheets

In Google Sheets, the ARRAY_CONSTRAIN formula returns a subset of the input range, characterized by the specified number of rows and...

How to use the DAVERAGE formula in Google Sheets

The DAVERAGE formula in Google Sheets is almost similar to that of the AVERAGEformula, but with a distinction. It gives us the average of...