Tips, tutorials, and add-ons
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
The IMAGE function lets a spreadsheet user insert a picture file into a cell. You must specify the source of the picture file as a URL. Syntax =IMAGE(url,[mode],[height],[width]) Video Tutorial Errors #N/A – The function does not have enough arguments. This error can occur because you used option #4 but did not specify height and … Read more
The WEEKNUM function accepts a date and returns the week number (1 through 54) of that date. To calculate the week number, the date must be in a valid format, so you have to use the DATE function, wrap it in quotes, or use a cell reference to a date. If your days, months, and … Read more
Learn how to use the DATEDIF function to find the number of years, months, or days between two dates.
The ISOWEEKNUM function accepts a date and returns the ISO week number (1 through 54) of that date. The date must be in a valid format, so you must use the DATE function, wrap it in quotes, or use a cell reference to a cell containing a date. An ISO week starts on Monday. The … Read more