Formulas & functions
How a function works, with worked examples you can paste.
- Date Difference in Minutes in Excel: Formulas That WorkIf A2 contains a start date and time and B2 contains an end date and time, enter =(B2-A2)*1440 to return the elapsed…
- Excel Date Calculator: Two Dates, Today, and FormulasTo calculate the number of days between two dates in Excel, put the earlier date in A2 and the later date in…
- Custom Text Filter in Excel: How to Use ItTo apply a custom text filter in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data >…
- Create a Sort List in Excel: Methods, Steps, and TipsTo create a sorted list in Excel, select a cell in your data and choose Data > Sort A to Z or…
- Create a Sequence of Dates in Excel: Formulas and FillTo create a sequence of dates in Excel, enter a starting date and use =SEQUENCE(10,1,DATE(2026,1,1),1) to spill ten consecutive dates down a…
- Create an Invoice in Excel With FormulasYes: create columns for quantities and unit prices, calculate each line total, add the lines for a subtotal, and use further formulas…
- Count Unique Values in Excel: Formulas and MethodsTo count distinct, nonblank values in Excel for Microsoft 365, use =ROWS(UNIQUE(FILTER(A2:A20,A2:A20<>""))). This assumes the values are in A2:A20; it counts each…
- COUNTIF Function to Find Duplicates in Excel: A GuideYes. In Excel, COUNTIF can find duplicates by counting how often each value appears: with values in A2:A7, enter =COUNTIF($A$2:$A$7,A2)>1 beside the…
- COUNTIF Negative Numbers in Excel: Formula and TipsIf your values are in A2:A20, count the negative numbers with =COUNTIF(A2:A20,"<0"). COUNTIF returns the number of cells whose numeric value is…
- COUNTIF in Excel: Find and Flag DuplicatesTo find duplicate values in Excel, use COUNTIF to count each value within the list: with values in A2:A100, enter =COUNTIF($A$2:$A$100,A2)>1 in…
- COUNTIF Formula to Find Duplicates in Excel and Flag ThemWith values in A2:A100, enter =COUNTIF($A$2:$A$100,A2)>1 in B2 and fill it down. TRUE marks a value that appears more than once in…
- COUNTIF Formula in Excel to Find Duplicates in a ListTo find duplicate values in Excel, enter =COUNTIF($A$2:$A$100,A2)>1 in a helper column beside your list, assuming the values are in A2:A100. It…
- COUNTIF Formula for Dates in ExcelIf your dates are in A2:A100 and the date to check is in D2, use =COUNTIF(A2:A100,D2) to count cells that match that…
- COUNTIF Excel Formula for Dates: Examples and FixesTo count cells that contain a particular date, use Excel’s COUNTIF function with a real date value as the criterion—for example, =COUNTIF(A2:A8,DATE(2026,1,15)).…
- COUNTIF Excel Number Range: Count Values by CriteriaTo count numbers in an Excel range that meet a condition, use COUNTIF: for example, with values in B2:B20, =COUNTIF(B2:B20,">=10") counts values…
- COUNTIF Drop-Down in Excel: Count SelectionsTo count how often an Excel drop-down choice appears, use =COUNTIF($B$2:$B$100,D2) when responses are in B2:B100 and the choice to count is…
- COUNTIF Excel: Count Dates by Day, Month, or RangeYes. Excel’s COUNTIF function can count dates that match a specific day or a condition such as before or after a date;…
- COUNT vs COUNTIF in Excel: Which One Should You Use?COUNT counts cells containing numbers, while COUNTIF counts cells that meet a condition you specify. Use COUNT for a numeric total; use…
- COUNTIF Between Dates in Excel: Formula and ExamplesTo count dates between two boundaries in Excel, use COUNTIFS with a lower-bound and an upper-bound condition. With dates in A2:A9 and…
- Count Unique Values in Excel Without DuplicatesTo count distinct, nonblank values in Excel, use =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,A2:A100<>""))),0) when your list is in A2:A100. The formula counts each different value once,…
- Copy and Transpose in Excel: Steps, Formulas, and TipsTo copy and transpose data in Excel for Microsoft 365 on Windows, select and copy the cells, choose the destination, then use…
- How to Copy a Conditional Formatting Formula in ExcelTo copy a conditional formatting formula in Excel, copy a cell with the rule and use Home > Paste > Paste Special…
- Convert Dates to Text in Excel: Formulas and MethodsIf the dates are real Excel dates in A2:A1000, enter =TEXT(A2,"mmmm d, yyyy") in B2 and fill it down; the result for…
- Conditional Formatting in Excel With IF FormulasTo use an IF formula in Excel conditional formatting, select the cells, choose Home > Conditional Formatting > New Rule > Use…
- Excel Conditional Formatting: Create a Formula RuleTo create a formula-based conditional formatting rule in Excel for Microsoft 365 on Windows, select the cells to format and choose Home…
- Concatenate Dates in Excel: Formulas and FormattingTo concatenate a date in Excel and keep it readable, combine the cell with the & operator and format the date with…
- How to Concatenate Names in Excel With a Space EasilyTo concatenate first and last names in Excel with a space, put the first name in A2 and the last name in…
- Concatenate Names in Excel: Formulas and ExamplesTo concatenate names in Excel, join the cells with the ampersand operator and add a space between them: if A2 contains Maria…
- Concatenate Names in Excel With a Comma?To concatenate names in Excel with a comma and a space, use =TEXTJOIN(", ",TRUE,A2:A4) when the names are in A2:A4; for two…
- Concatenate Dates and Text in Excel: Formula GuideTo concatenate a date and text in Excel, convert the date to readable text with the TEXT function, then join it with…