Tips, tutorials, and add-ons
The WORKDAY.INTL function calculates a workday a given number of workdays away from a date. You can optionally specify a list of holidays to exclude from the count and other weekends. If your days, months, and years are in separate cells, use the DATE function to combine them. This function is different from the WORKDAY … Read more
Without formulas, Google Sheets would be the same as a paper ledger. Formulas allow you to write a set of instructions for a calculation. All formulas begin with an = sign. Once you type the =, Google Sheets expects a formula to follow. There are several ways to proceed with your formula. Listed below are … Read more
The DATEVALUE function accepts a date value in any valid format and returns it as a serial number. Spreadsheets store dates and times as serial numbers in Google Sheets, so they work in formulas (you can add March plus June). You can use the DATEVALUE function to prepare dates to be sorted, filtered, or used in formulas. … Read more
The SUM function is the most popular function in Google Sheets. The syntax is easy to remember and works similarly across most spreadsheet programs. Feel free to copy the template with these examples to follow along. Purpose This function returns the total of a series of numbers, cells, or both. Video Explanation Syntax =SUM(value1, [value2,…]) Related Functions … Read more
The ARRAYFORMULA function is a powerful tool in Google Sheets that allows you to spread formula outputs across multiple rows and columns. It can extend non-array functions such as SUM, PRODUCT, or AVERAGE. As with other functions that generate arrays, such as FILTER and QUERY, the output needs space to expand below and right. Keep … Read more