Formulas & functions
How a function works, with worked examples you can paste.
- DATEDIF in Excel: Calculate Completed Months Between DatesIn Excel, use =DATEDIF(A2,B2,"m") to count the complete months between a start date in A2 and an end date in B2. The…
- Date to Fiscal Year in Excel: Formulas and ExamplesTo convert a date to a fiscal year in Excel, compare its month with your fiscal year-end month. If dates are in…
- Date to Weekday Formula in Excel: WEEKDAY and TEXTTo convert a date into its weekday number in Excel, use =WEEKDAY(A2,2), assuming the date is in cell A2; Monday returns 1…
- Date Sort in Excel: Steps, Fixes, and Sorting TipsTo sort dates in Excel, select a cell in the date column, open the Data tab, and choose Sort Oldest to Newest…
- Date Minus Days Formula in Excel: Examples and TipsTo subtract days from a date in Excel, use a minus sign: if A2 contains a date and B2 contains the number…
- Date Sequence in Excel: Create a List of DatesIn Excel for Microsoft 365 on Windows, enter =SEQUENCE(10,1,DATE(2026,1,1),1) in an empty cell to create ten consecutive daily dates beginning January 1,…
- Daily Timesheet Excel Formula: Calculate Hours CorrectlyFor a daily timesheet with a start time in B2, an end time in C2, and an unpaid break duration in D2,…
- Daily Timesheet Template in Excel: Setup and FormulasA practical daily timesheet template in Excel can use one row per employee per workday, with columns for the date, employee, start…
- Daily Attendance Template Excel: Setup and FormulasA daily attendance template in Excel is a worksheet with one row per person, one column per date, and a consistent code…
- Daily Attendance Sheet in Excel With FormulasTo make a daily attendance sheet in Excel, put employee or student names in column A, dates across row 1, and a…
- Create an Invoice in Excel With Formulas and TotalsCreate an invoice in Excel by setting up columns for descriptions, quantities, unit prices, and line amounts, then adding formulas for the…
- Count Unique Values in Excel With One or More CriteriaIn Microsoft 365 for Windows, count distinct nonblank values that meet one condition with =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,(B2:B100=E2)*(A2:A100<>"")))),0). This counts the unique entries in A2:A100…
- Count Unique Values in an Excel ColumnTo count distinct, nonblank values in an Excel column, use =COUNTA(UNIQUE(FILTER(A2:A100,A2:A100<>""))) in Excel for Microsoft 365 or Excel 2021 and later. Replace…
- Count Unique Values in an Excel PivotTable: A Clear GuideTo count unique values in an Excel PivotTable, create the PivotTable with Add this data to the Data Model selected, place the…
- Count Unique Numbers in Excel: Formulas and MethodsTo count distinct numeric values in a range in Microsoft 365 or Excel 2021, use =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,ISNUMBER(A2:A100)))),0), assuming the numbers are in A2:A100.…
- Count Unique Text Values in Excel: Formulas & TipsTo count unique, nonblank text values in Excel for Microsoft 365, use =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,ISTEXT(A2:A100)*(A2:A100<>"")))),0) when the values are in A2:A100. It returns the…
- Counting Unique Values in Excel: Formulas and MethodsTo count distinct, nonblank values in Excel for Microsoft 365, use =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,A2:A100<>""))),0) when your values are in A2:A100. It returns the number…
- Count Unique Entries in Excel: Formulas and TipsTo count distinct, nonblank entries in Excel for Microsoft 365, use =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,A2:A100<>""))),0), replacing A2:A100 with your data range. The formula returns the…
- Count Unique Cells in Excel: Formulas and ExamplesTo count distinct, nonblank values in Excel for Microsoft 365, use =COUNTA(UNIQUE(FILTER(A2:A10,A2:A10<>""))). This assumes the values are in A2:A10; if the range…
- COUNTIFS in Excel: How to Count with Multiple CriteriaYes. Excel’s COUNTIFS function counts rows or cells that meet multiple criteria at the same time. For example, with regions in A2:A100…
- COUNTIFS Greater Than in Excel: Criteria and ExamplesTo count values greater than a number in Excel, use COUNTIFS with the greater-than operator inside a quoted criteria string: =COUNTIFS(B2:B10,">100"). Replace…
- COUNTIFS Unique in Excel? Count Distinct MatchesYes. To count distinct values that meet multiple criteria in Microsoft 365, use =IFERROR(ROWS(UNIQUE(FILTER(C2:C8,(A2:A8=E2)*(B2:B8=F2)*(C2:C8<>"")))),0). With categories in A2:A8, regions in B2:B8, names…
- COUNTIFS Excel Formula: Multiple Criteria and ExamplesUse Excel’s COUNTIFS function to count rows that meet two or more conditions: =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...). It applies an AND…
- COUNTIF Not N/A in Excel: Formula and Errors ExplainedTo count cells that are not the literal text N/A, use =COUNTIF(A2:A20,"<>N/A"). If blank cells should not count either, use =COUNTIFS(A2:A20,"<>N/A",A2:A20,"<>"); if…
- COUNTIF Values in Excel: Count Text, Numbers, and MoreIn Excel, use =COUNTIF(range,criteria) to count cells in a range that meet one condition. For example, with order statuses in A2:A20, =COUNTIF(A2:A20,"Paid")…
- COUNTIF Not Blank Text in Excel: Formula and ExamplesTo count cells containing text in Excel, use =COUNTIF(A2:A100,"*"), replacing A2:A100 with your range. The asterisk is a wildcard: it matches text,…
- COUNTIF Not Duplicate in Excel: Count Unique ValuesTo count values that appear only once in Excel, use =SUMPRODUCT((A2:A10<>"")*(COUNTIF(A2:A10,A2:A10)=1)) when the values are in A2:A10; it ignores blanks and returns…
- COUNTIF Not in Excel? Count Values That Do Not MatchExcel does have the COUNTIF function; there is no separate function called COUNTIFNOT. To count cells that do not match a value,…
- COUNTIF Less Than 1 in Excel: Formula and ExamplesTo count values less than 1 in Excel, use =COUNTIF(A2:A100,"<1") when the values are in A2:A100. It counts qualifying entries such as…
- Excel COUNTIF Less Than a Cell: Formula and ExamplesTo count values in Excel that are less than a value in another cell, use =COUNTIF(B2:B20,"<"&D2). This assumes the values are in…