Formulas & functions
How a function works, with worked examples you can paste.
- Concatenate Dates in Excel Without Losing Their FormatIf A2 contains Invoice date: and B2 contains March 4, 2026, join them with =A2&" "&TEXT(B2,"mmmm d, yyyy"). The TEXT function preserves…
- Concatenate in Excel: Can You Keep Cell Formatting?No—Excel’s CONCAT, CONCATENATE, TEXTJOIN, and the & operator join cell contents, but they do not carry the source cells’ formatting into the…
- Concatenate 2 Dates in Excel: Formulas and FormattingTo concatenate two dates in Excel, convert each date to readable text with TEXT, then join the results with the ampersand operator.…
- How to Concatenate in Excel and Keep Leading ZerosTo concatenate values in Excel and keep leading zeros, format the value with TEXT inside the formula before joining it to anything…
- Compare Two Lists in Excel to Find Unique ValuesTo find values in one Excel list that are missing from another, use FILTER with XMATCH; wrap the result in UNIQUE to…
- Compare Two Columns in Excel with XLOOKUPTo check whether each value in column A appears anywhere in column B, enter =IF(ISNA(XLOOKUP(A2,$B$$2:$B$100,$B$2:$B$100,,0)),"Not found","Match") in C2 and fill it down.…
- Color Picker in Excel: Choose and Match Colors PreciselyIn Excel for Microsoft 365 on Windows, select the cell or range, then go to Home > Fill Color and choose a…
- Clear a Filter in an Excel Table: Steps and OptionsTo clear a filter in an Excel table, open the drop-down arrow in the filtered column’s header and choose Clear Filter From…
- CLEAN vs TRIM in Excel: Which Function Should You Use?In Excel, use CLEAN to remove certain nonprinting control characters from text, and use TRIM to remove ordinary extra spaces: TRIM removes…
- Checklist Examples in Excel: Templates and FormulasUseful checklist examples in Excel include task lists, inspections, inventory counts, event plans, and habit trackers. For a basic interactive list in…
- Check for a Match in Excel: Formulas, Methods, and TipsTo check whether a value in Excel appears in a list, use =IF(COUNTIF($B$2:$B$20,A2)>0,"Match","No match"). With the value to check in A2 and…
- Change Text Filter to Number Filter in Excel?To change a Text Filters menu to Number Filters in Excel, convert the values in that column from text to real numbers,…
- Cash Flow Formula in Excel: A Step-by-Step TutorialIn Excel, net cash flow for a period is cash inflows minus cash outflows. If inflows are in column B and outflows…
- Capitalize Words in Excel: Formulas and Other MethodsTo capitalize the first letter of every word in Excel, use the PROPER function: if the text is in A2, enter =PROPER(A2)…
- Capitalize Names in Excel: Formulas and MethodsTo capitalize names in an Excel column, enter =PROPER(A2) in the next column, replacing A2 with the first name cell, then fill…
- Cannot Filter in Excel? Causes, Checks, and FixesYes—Excel can filter both ordinary data ranges and tables. In Microsoft 365 for Windows, select a cell in your data and choose…
- Can’t Filter in Excel? Causes, Fixes, and WorkaroundsYes—Excel can filter a list or table, but the Filter command may be unavailable, the dropdown arrows may be missing, or a…
- Can You Sort Excel by Color? Steps and TipsYes. In Excel for Microsoft 365 on Windows, select your data and choose Data > Sort, then set Sort On to Cell…
- Rank Low to High in Excel: Formulas, Sorting, and TipsYes. To assign ranks with the lowest value as rank 1, use Excel’s RANK.EQ function with its order argument set to 1;…
- Filter by Text Color in Excel: Steps, Limits, and TipsYes. In Excel for Microsoft 365 on Windows, you can filter a column by font color: open its filter arrow, choose Filter…
- Can You Filter by Bold Text in Excel?No—not directly. Excel for Microsoft 365 on Windows can filter a range by values, cell color, font color, and icons, but its…
- Can You Filter Out Duplicates in Excel? Methods That WorkYes. In Excel for Microsoft 365 on Windows, you can identify duplicates with conditional formatting, filter them with a formula, extract unique…
- Calendar Day Formula in Excel: Dates, Weekends & MoreFor the day number within a date, use =DAY(A2), where A2 contains an Excel date; for example, January 15 returns 15. To…
- Calculating Due Dates in Excel With Simple FormulasTo calculate a due date in Excel, add the number of calendar days to a valid start date: with the start date…
- Calculating Hours Worked in Excel: Formulas & TipsTo calculate hours worked in Excel, put a shift’s start time in A2 and end time in B2, then enter =MOD(B2-A2,1)*24 in…
- Calculate Weekdays Between Dates in Excel: FormulasTo calculate weekdays between two dates in Excel, use =NETWORKDAYS(A2,B2), where A2 contains the start date and B2 the end date. It…
- Calculate Quarterly Dates in Excel: Formulas and ExamplesTo calculate a calendar quarter’s first day in Excel, put a date in A2 and enter =DATE(YEAR(A2),3*INT((MONTH(A2)-1)/3)+1,1); for May 17, 2026, the…
- Calculate Age in Excel with DATEDIF: Formula and TipsTo calculate someone’s age in completed years in Excel, enter their birth date in A2 and use =DATEDIF(A2,TODAY(),"Y"). DATEDIF compares the start…
- Budget vs Actual Excel Formula: Examples and SetupIf budget is in B2 and actual spending or revenue is in C2, the basic budget-versus-actual formula is actual minus budget: =C2-B2.…
- AVERAGEIFS Between Two Dates: Excel Formula & ExamplesWith dates in A2:A100, values to average in B2:B100, a start date in E2, and an end date in F2, use =AVERAGEIFS(B2:B100,A2:A100,">="&E2,A2:A100,"<="&F2).…