Each tool gives you the answer and the formula that produces it, written for your own cell references. Everything runs in your browser.
All tools
Formula Explainer
Paste any formula and see each function and reference in plain English.
Open the tool →Date Difference Calculator
Days, months, years and weekdays between two dates, with the DATEDIF formulas.
Open the tool →Lookup Formula Builder
Builds XLOOKUP, VLOOKUP and INDEX/MATCH for your exact ranges.
Open the tool →Loan Payment (PMT) Calculator
Payment, total interest, schedule, and the PMT, IPMT and PPMT formulas.
Open the tool →Percentage Formula Generator
Percent of, percent change, increase and decrease, with the formula.
Open the tool →Date Serial Number Converter
Turn 45000 into a date and back, in the 1900 or 1904 system.
Open the tool →Column Letter to Number
AA is 27, XFD is 16,384. Converts both ways.
Open the tool →Which tool do I need?
- A formula from someone else that you do not follow: Formula Explainer.
- Pulling a price, name or ID from another table: Lookup Formula Builder.
- Age, tenure, days until a deadline, working days: Date Difference Calculator.
- A number like 45000 where a date should be: Date Serial Number Converter.
- Monthly payments and an amortization table: Loan Payment (PMT) Calculator.
- Discounts, growth, margins and shares: Percentage Formula Generator.
- Column numbers for VBA, INDEX or OFFSET: Column Letter to Number.