Small tools that do one job well. They run entirely in your browser, need no account and do not send what you type anywhere. Each one shows the Google Sheets formula behind the result, so you can check it and use it in your own sheet.
Date formula generator
Build formulas for days between dates, working days, age, adding months or working days, the day of the week and the last day of the month. Try them with your own dates before you paste them.
Conditional formatting formula generator
Get the custom formula and the range for the most common rules: checked checkboxes, text, overdue dates, weekends, duplicates and top values. Every dollar sign is explained.
QUERY formula generator
Build a QUERY formula with filters, dates, values from a cell, totals by group, sorting by several columns and data from another tab or spreadsheet, with every quote in the right place.
Lookup formula generator
Get an XLOOKUP, INDEX MATCH, VLOOKUP or FILTER formula for up to three conditions, several result columns, the last match or a “not found” text. It adds ARRAYFORMULA where Google Sheets needs it.
COUNTIFS and SUMIFS formula generator
Count, add up or average the rows that meet up to three conditions: text, numbers, dates, “contains”, blank or “between”. It writes the quotes, the & and the end date of a range so they work first time.
Formula checker and separator converter
Paste a formula to find unclosed brackets and quotes, curly quotes and Excel-only syntax, and convert it between comma and semicolon locales, including arrays and decimals.
Column letter to number converter
Convert a column letter such as AA or XFD to its number, or a number to its letter, with the formulas to do the same inside a sheet.