Formulas & functions
How a function works, with worked examples you can paste.
- Compare Two Columns in Excel: Formulas and MethodsTo compare two columns in Excel row by row, enter =A2=B2 in a third column and fill it down; TRUE means the…
- EDATE in Excel: Use It for Months, Not DaysExcel’s EDATE function moves a date forward or backward by a number of months, not by a number of days. To add…
- EDATE Function in Excel: Add Months to DatesIn Excel, EDATE adds or subtracts a specified number of whole months from a date. With a starting date in A2 and…
- EDATE in Excel: Meaning, Formula, and ExamplesEDATE in Excel means “end date” in the sense of a date a chosen number of months before or after a starting…
- EDATE Formula in Excel: Add or Subtract Months from DatesUse Excel’s EDATE function to move a date forward or backward by a specified number of months. If the starting date is…
- Dynamic Range Formula in Excel: Methods and ExamplesA dynamic range in Excel expands or contracts as data is added or removed. For a contiguous list beginning in A2, a…
- Excel OFFSET Function: Dynamic Ranges and ExamplesIn Excel, OFFSET is a function that returns a reference shifted a specified number of rows and columns from a starting cell…
- Due Date Calculator in Excel: Formulas and ExamplesFor a basic due date calculator in Excel, enter a start date in A2 and the number of calendar days in B2;…
- Dynamic Array Formulas in Excel: How They WorkA dynamic array formula in Excel returns multiple results that spill automatically into neighboring cells, so one formula can fill a whole…
- Double Match in Excel: Find Rows Using Two CriteriaTo find a row that matches two criteria in Excel, use XLOOKUP with a condition for each column: =XLOOKUP(1,(A2:A100=E2)*(B2:B100=F2),C2:C100,"Not found"). With IDs…
- Due Date Calculation in Excel: Formulas and Examples GuideFor a due date a set number of calendar days after a start date, put the start date in A2 and the…
- Weighted Average in Excel: Formulas, Examples, and TipsTo calculate a weighted average in Excel, multiply each value by its weight, add those products, and divide by the sum of…
- DMAX Function in Excel: Syntax, Examples, and CriteriaExcel’s DMAX function returns the largest numeric value in a selected column of a database-like table, but only from rows that meet…
- DMAX Formula in Excel: Syntax, Examples, and CriteriaExcel’s DMAX function returns the largest numeric value in a database field among records that meet specified criteria. For example, with a…
- Divide Symbol in Excel: How the / Operator Works in FormulasIn Microsoft Excel, the division operator is the forward slash, /. To divide one cell by another, enter a formula such as…
- Discounted Cash Flow Formula in Excel: A Practical GuideIn Excel, a basic discounted cash flow (DCF) formula is =NPV($B$2,B5:B9)+B10/(1+$B$2)^5. With the discount rate in B2, cash flows for years 1–5…
- Depreciation Calculation in Excel: Formulas and ExamplesTo calculate depreciation in Excel, enter an asset’s cost, salvage value, useful life, and period, then use a function such as =SLN(B2,B3,B4)…
- Depreciation Table in Excel: Methods, Formulas, and SetupA depreciation table in Excel tracks an asset’s cost, estimated salvage value, useful life, depreciation expense, and remaining book value over time.…
- Depreciation Expense Formula in Excel: Methods & ExamplesIn Excel, calculate straight-line depreciation with =SLN(cost,salvage,life); for example, =SLN(24000,4000,5) returns $4,000 per year. Excel also has built-in functions for declining-balance and…
- Dense Rank in Excel: Formulas and ExamplesTo calculate a dense rank in Excel, give equal values the same rank and do not leave gaps after ties. With scores…
- Debt Payoff Formulas for Excel: A Practical GuideExcel can estimate a debt payment with =PMT(B2/12,B3,-B1), estimate how many monthly payments a balance will take with =NPER(B2/12,-B4,B1), and track each…
- Debt Payment Excel Formula: Calculate Your Monthly CostIn Excel, use the PMT function to calculate a fixed monthly debt payment: =-PMT(annual_rate/12,number_of_months,balance). For example, a $12,000 balance at 18% annual…
- Days Left in Excel: Calculate Workdays and Calendar DaysTo calculate days left in Excel, subtract today’s date from the deadline: if the deadline is in A2, enter =A2-TODAY() in another…
- Days Left in Month in Excel: Formula and Examples for DatesIf the date is in A2, use =EOMONTH(A2,0)-A2 to count the days remaining after that date, not including the date itself. For…
- DATEDIF in Excel: Is It Still Available?Yes—DATEDIF still works in Microsoft Excel for Microsoft 365, even though it is a legacy function that may not appear in autocomplete…
- DATEDIF Not in Excel? How to Use the Hidden FunctionDATEDIF is available in Excel for Microsoft 365 on Windows, but it is a hidden compatibility function: it may not appear in…
- Days Left Formula in Excel: Calculate Time RemainingTo calculate days left in Excel, put the deadline in A2 and enter =A2-TODAY() in another cell. The result is the number…
- DATEDIF in Excel: Formula, Examples, and Common ErrorsThe DATEDIF formula in Excel calculates the time between two dates in days, months, or years: =DATEDIF(start_date,end_date,unit). It is useful for finding…
- Date to Weekday in Excel: Formulas and FormattingTo turn a date into its weekday in Excel, use =TEXT(A2,"dddd") if the date is in A2; it returns the weekday name,…
- DATEDIF Formula in Excel: Calculate Years and MonthsTo calculate completed years and the remaining whole months between two dates in Excel, use =DATEDIF(A2,B2,"y") for years and =DATEDIF(A2,B2,"ym") for leftover…