Formulas & functions
How a function works, with worked examples you can paste.
- Average Time Between Dates in Excel: Formula & ExamplesTo calculate the average time between consecutive dates in Excel, subtract each date from the one below it, then average those differences.…
- AVERAGEIF in Excel: What It Returns and How to Use ItAVERAGEIF is not a number in Excel; it is a worksheet function that calculates the average of cells meeting one condition, and…
- AVERAGE vs AVERAGEIF in Excel: Which Should You Use?Use AVERAGE to find the mean of numeric values in a range; use AVERAGEIF to average only values that meet one condition.…
- Average Days Between Dates in Excel: Formulas & TipsIf your dates are listed in chronological order in A2:A10, enter =AVERAGE(A3:A10-A2:A9) to calculate the average number of days between consecutive dates…
- Average Between Dates in Excel: Formula and ExamplesTo average values between two dates in Excel, use =AVERAGEIFS(B2:B100,A2:A100,">="&D2,A2:A100,"<="&E2). This averages the numbers in B2:B100 whose corresponding dates in A2:A100 fall…
- Average Between Two Dates in Excel: Formulas & TipsTo average values whose dates fall between two dates in Excel, use =AVERAGEIFS(B2:B100,A2:A100,">="&E2,A2:A100,"<="&F2). This averages numbers in B2:B100 where the corresponding dates…
- How to Delete an Array Formula in Excel Without ErrorsTo delete an array in Excel, remove its formula: select the entire output range for a legacy array formula and press Delete;…
- Align Right in Excel: Shortcut, Menu, and Mac KeysIn Excel for Microsoft 365 on Windows, select the cell or range and press Alt, H, A, R—one key after another, not…
- Align Left Shortcut Key in Excel for Windows and MacIn Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, A, L, one key after another,…
- Age From DOB in Excel: DATEDIF Formula and ExamplesTo calculate age in completed years from a date of birth in Excel, enter the birth date in A2 and use =DATEDIF(A2,TODAY(),"Y").…
- Excel DATEDIF Age Formula: Calculate Years, Months, DaysTo calculate someone’s age in completed years in Excel, use =DATEDIF(A2,TODAY(),"Y"), with the date of birth in A2. For a fixed or…
- Age Formula in Excel Without DATEDIFTo calculate age in completed years in Excel without DATEDIF, put a birth date in A2 and enter =YEAR(TODAY())-YEAR(A2)-IF(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))>TODAY(),1,0) in another cell.…
- Excel DATEDIF Age Formula: Calculate Years, Months & DaysTo calculate someone’s age in completed years in Excel, enter their birth date in A2 and use =DATEDIF(A2,TODAY(),"Y"). DATEDIF compares the birth…
- Add a Sort List in Excel: Create a Custom OrderTo add a custom sort list in Excel for Microsoft 365 on Windows, go to File > Options > Advanced, find the…
- Add M to a Number in Excel: Formula and FormattingTo add an M after a number in Excel, apply a custom number format such as #,##0"M" to keep the value numeric,…
- Add Days to Date in Excel vs. EDATEIf A2 contains a date and B2 contains a number of calendar days, add days in Excel with =A2+B2. Use EDATE when…
- Access Database vs Excel: How to Choose the Right ToolChoose Microsoft Access when you need a structured database with related tables, forms, and repeatable queries; choose Excel when you need flexible…
- Power Query Add Column: Custom, Conditional, and IndexTo add a column in Power Query for Excel, open the query in Power Query Editor, select the Add Column tab, and…
- Excel Named Range Sort: Sort Data or Name DefinitionsIn Excel, a named range is a label for a cell or group of cells, not a separate list that you can…
- Excel Named Range Not Appearing in Formula? FixesIf an Excel named range is not appearing as you type a formula, first confirm that the name exists and is in…
- Excel Named Range in a Formula: How to Use It CorrectlyIn Excel, use a named range in a formula by typing its name where you would normally put a cell reference—for example,…
- Excel: Merge Date and Time Cells Into One Cell With FormulaTo combine a date in A2 and a time in B2 into one Excel date-and-time value, enter =A2+B2 in C2, then format…
- Excel Merge Cells Per Row: The Right Way to Do ItTo merge cells separately across each row in Excel for Microsoft 365 on Windows, select the full range and choose Home >…
- Excel Merge Data From 2 Cells: Formulas and MethodsTo merge the contents of two cells in Excel, combine them with a formula such as =A2&" "&B2. If A2 contains Ada…
- Excel Link to Named Range: Formulas and MethodsTo create a clickable link to a named range in Excel for Microsoft 365 on Windows, use the HYPERLINK function with the…
- Excel Joining Two Text Columns: Formulas and ExamplesTo join two text columns in Excel, enter a formula such as =A2&" "&B2 in a third column, assuming A2 contains Maya…
- Excel Join Text From Two Columns: Formulas and TipsTo join text from two Excel columns on the same row, enter =A2&" "&B2 in a third column and fill the formula…
- Excel Insert Row Automatically Add Formula?Yes—Excel can automatically add a formula when you insert a row, most reliably when the data is an Excel Table and the…
- Excel INDEX MATCH With Table Structured ReferencesYes—Excel INDEX MATCH works with table structured references. For example, if a table named Inventory has columns Item and Unit Price, and…
- Excel Import CSV: Formula or the Right Import MethodExcel does not have a built-in worksheet formula that imports a CSV file from your computer. In Microsoft 365 for Windows, use…