Formulas

If you’re working with dates in Google Sheets and you need to find the difference between two dates, the DATEDIF function will come in handy. In this tutorial, I will …

If you need to generate an array with random numbers in your spreadsheet, the RANDARRAY function will come in handy. This is an array version of the RAND function which …

Google Sheets has a number of useful date functions that can be used to do many different things. One useful built-in date function in the WEEKNUM function. In this tutorial, …

Google Sheets can perform many useful statistical calculations if you use the right functions. One such useful statistical function that is available in Google Sheets is the LINEST function. With …

There may be times when working in Google Sheets that you want to put an entire range of data into a single column. Luckily there is a built-in function called …

If you are regularly working with arrays in Google Sheets, there are a number of built-in ARRAY functions that are useful to know about. One such function is the ARRAY_CONSTRAIN …

The ISBLANK function is a simple way to check whether a cell is empty or not. It’s a pretty straightforward function that is very easy to use. In this tutorial, …

Google Sheets is very useful for making all sorts of different calculations with data. There are a ton of different formulas that you can use in your spreadsheet depending on …

The ADDRESS function in Google Sheets will return a cell reference as a string. This is not a very well-known function, but when you work with spreadsheets long enough, you …

If you want to know the number of net working days between two dates, the NETWORKDAYS function will come in handy. In this tutorial, I will show you how to …