There might be times when you want to know what weekday it is on a specific date in Google Sheets For example, you may want to know the weekday on your birthday, or on the first date of the next month. In such cases, you can use the Google Sheets day of week (WEEKDAY) Function. …
https://www.youtube.com/watch?v=-z587aoPhCcGoogle Sheets has some useful functions that are not available in Excel (such as IMPORTRANGE, QUERY, IMPORTDATA, etc.) One such extremely powerful one is the FILTER function. Using the FILTER function in Google Sheets allows to instantly filter the source data to find specific information. What makes it so powerful is that it doesn’t need us to use any complex functionality …
OR function is useful when you want to evaluate a set of conditions. It will return TRUE when any of the conditions being checked are met, else it returns FALSE. Let’s dive into our OR function Google Sheets guide. OR Function Google Sheets Syntax OR in Google Sheets works with the following syntax: OR(logical_expression1, [logical_expression2, …]) …
The IFS Google Sheets function lets you easily test multiple conditions in a single formula. While the functions can get long and seem daunting, once you understand them,y ou’ll be applying them fluently. This guide aims to teach you everything you need to know about IFS statements in Google Sheets to get started quickly. Read …
If you work with formulas in Google Sheets, you know that errors can pop up any time. While getting errors is a part of working with formulas in Google Sheets, it’s important to know how to handle them correctly. In this tutorial, I will show you how to use the IFERROR Google Sheets function to …
The VLOOKUP Google Sheets function can be used to look for a value in a column and when that value is found, return a value from the same row from a specified column. Now if that description sounds nerdy and difficult, here is another way to understand what this function does. Suppose you have gone …
Ready take your Google Sheets skills to the next level? Want to lift your productivity without breaking a sweat?
Sign up for our free newsletter for regular spreadsheet guidance.
Enjoy our custom-made Google Sheets templates for free via email access
