Formulas & functions
How a function works, with worked examples you can paste.
- DATEDIF Formula Examples for Excel: Years, Months & DaysIn Excel, DATEDIF calculates the time between two dates in completed years, months, or days. For example, if A2 contains January 15,…
- DATEDIF Spreadsheet Examples: Years, Months, and DaysIn Excel for Microsoft 365, use DATEDIF(start_date,end_date,unit) to calculate the elapsed time between two dates in completed years, months, or days. For…
- DATEDIF Excel Function: Examples and Common IssuesExcel’s DATEDIF function calculates the time between two dates in years, months, or days. For example, with a start date in A2…
- COUNTIF in Excel: How It Works and ExamplesIn Excel, COUNTIF counts cells in a range that meet one condition. Its syntax is =COUNTIF(range, criteria); for example, with regions in…
- COUNTIF Criteria Examples for ExcelIn Excel for Microsoft 365, COUNTIF counts cells in one range that meet one condition: enter the range and a criterion such…
- COUNTIF Data Analysis Examples in ExcelCOUNTIF data analysis examples show how to count spreadsheet records that meet a rule, such as a region, a sales threshold, a…
- COUNTIF Calculation Examples: Text, Dates, and NumbersCOUNTIF counts cells in a range that meet one condition, such as a number, text value, date, or blank. With the numbers…
- Conditional Formatting Dates in Excel: Rules and FormulasTo conditionally format dates in Excel for Microsoft 365 on Windows, select the date cells and choose Home > Conditional Formatting >…
- Basic IF Examples in Excel: How to Write the FormulaIn Excel, an IF formula checks whether a condition is true and returns one value if it is, or another value if…
- VLOOKUP to Compare Two Columns on Different SheetsYes. In Excel for Microsoft 365, use an exact-match VLOOKUP to check whether each value in one sheet’s column appears in a…
- Using VLOOKUP to Compare Two Sheets in Excel Step by StepTo compare records on two Excel sheets, use VLOOKUP with an exact match and test whether it finds each key. If Sheet1…
- Excel Set Print Area: How to Print the Right CellsTo set a print area in Microsoft Excel for Microsoft 365 on Windows, select the cells you want to print, then choose…
- How to Tell If Your Excel File Is Corrupted: Key SignsYou can suspect an Excel file is corrupted if Excel cannot open it, displays a repair warning, or shows damaged or missing…
- Split a Cell in Excel: Text to Columns, Formulas, and MoreYes. In Microsoft Excel, select the cells and choose Data > Text to Columns to split their contents using a delimiter such…
- Excel Formula Not Calculating? Common Causes and FixesIf a formula will not calculate in Excel, check that the cell is not formatted as Text, that the formula begins with…
- Find and Replace Formula in Excel: SUBSTITUTE or REPLACEIn Excel, use SUBSTITUTE to replace matching text inside a cell, or REPLACE to replace characters at a specified position. For a…
- Excel Power Automate Filter Query: Syntax and ExamplesIn Power Automate, filter Excel table rows by entering an OData-style condition in the Filter Query field of the Excel Online (Business)…
- Excel VLOOKUP Shortcut Keys: What Actually WorksExcel has no dedicated keyboard shortcut that inserts or runs VLOOKUP by itself. The quickest keyboard approach is to type =VLOOKUP( and…
- Excel Unique Dropdown List: Create One That UpdatesTo create a unique dropdown list in Excel for Microsoft 365, generate a deduplicated list with UNIQUE, then use that spilled range…
- Excel SUMIF: Sum Columns When a Cell Contains TextTo add values in one column only when the corresponding cell in another column is exactly x, use Excel’s SUMIF function. For…
- Excel Split Cell After First Space: Formulas and StepsTo split text in Excel after its first space, use =TEXTBEFORE(A2," ") for the text before the space and =TEXTAFTER(A2," ") for…
- Excel Slicer to Filter Data: How to Set Up and Use ItTo filter data with an Excel slicer, select a table cell and choose Table Design > Insert Slicer, or select a PivotTable…
- Excel Slicer Custom Sort Order: How to Set ItTo give an Excel slicer a custom order, create an Excel custom list containing the slicer items in the order you want,…
- Excel Scenario Manager Examples for What-If AnalysisExcel Scenario Manager examples include comparing low, expected, and high sales forecasts, testing different staffing plans, or checking how input costs affect…
- Excel Scenario Manager Tutorial: Compare What-If PlansTo use Excel Scenario Manager, build a worksheet model, then select Data > What-If Analysis > Scenario Manager > Add to save…
- Excel Protect Sheet: Allow Users to Filter and SortYes. In Excel for Microsoft 365 on Windows, turn on the filter before protecting the worksheet, then choose Review > Protect Sheet…
- Excel Protect Sheet From Being Deleted: The Right SettingTo stop a worksheet from being deleted in Excel for Microsoft 365 on Windows, protect the workbook’s structure: go to Review >…
- Excel Power Query vs Formulas: Which Should You Use?Use Excel formulas when you want calculations to update as you edit worksheet cells; use Power Query when you need to import,…
- Excel Power Query Filter Rows: Practical Steps and ExamplesTo filter rows in Excel Power Query, open a query in the Power Query Editor, select the filter arrow in a column…
- Excel PivotChart: How to Count Unique ValuesYes. In Excel for Microsoft 365 on Windows, you can count unique values in a PivotChart by building its PivotTable from the…