Formulas & functions
How a function works, with worked examples you can paste.
- Excel Text Plus Cell Value: Formulas, Formatting, and FixesTo combine text with a cell value in Excel, join them with the ampersand operator (&). For example, if A2 contains 104,…
- Excel Text Right of Character: Formulas and ExamplesTo return the text to the right of a character in Excel, use TEXTAFTER in Microsoft 365 or Excel 2024, such as…
- Excel Text Length: Character Limits and the LEN FunctionExcel cells can contain up to 32,767 characters, and the LEN function counts the characters in a cell’s contents. For example, if…
- Excel Text Left of a Character: Formulas and ExamplesTo return the text before a character in Excel, combine LEFT with FIND: if A2 contains INV-2048, enter =LEFT(A2,FIND("-",A2)-1) to get INV.…
- Excel TEXT Function Format Codes ExplainedExcel TEXT format codes are patterns you pass to the TEXT function to turn a number, date, time, or percentage into formatted…
- Excel Text Expansion: AutoCorrect, Formulas, and MoreExcel has no single feature called “text expansion,” but you can make a short abbreviation expand as you type with AutoCorrect: on…
- Excel Text Compare: Formulas and Practical MethodsTo compare text in two Excel cells, use =A2=B2 for a case-insensitive comparison or =EXACT(A2,B2) when capitalization must match. Both formulas return…
- Excel Time Subtraction: Formulas and Overnight TimesTo subtract one time from another in Excel, subtract the start time from the end time: with a start time in A2…
- Excel Time Plus Minutes: Formulas and FixesTo add minutes to an Excel time, add the minutes divided by 1,440: with a time in A2 and a number of…
- Excel Time Formulas: Calculate Overnight PM-to-AM HoursIf A2 contains a PM start time and B2 contains the following AM finish time, enter =MOD(B2-A2,1) to calculate the elapsed time…
- Excel Time Math: Formulas for Adding and Subtracting HoursExcel time math treats times as fractions of a 24-hour day: subtract an earlier time from a later one with =B2-A2, or…
- Excel Time Converter: Formulas, Formats, and TipsTo convert decimal hours in Excel into a time value, divide by 24; to convert an Excel time value into decimal hours,…
- Excel Time Between Two Timestamps: Formulas and TipsIf the start timestamp is in A2 and the end timestamp is in B2, enter =B2-A2 to calculate the elapsed time. Format…
- Excel Time Between Two Times: Formulas and Overnight ShiftsTo calculate the time between two times in Excel, subtract the start time from the end time: if the start is in…
- Excel Time Addition: Formulas, Formatting, and FixesTo add times in Excel, enter the values in cells and add them with a formula: if a start time is in…
- Excel Date Subtraction: Formulas, Days, and WorkdaysTo subtract one date from another in Excel, subtract the earlier date cell from the later one: if the start date is…
- Excel Date Plus Years: Formula and Leap-Year RulesTo add years to a date in Excel, use =EDATE(A2,12*B2), where A2 contains the starting date and B2 contains the number of…
- Excel Date Plus 3 Months: Formula, Rules, and ExamplesTo add three calendar months to a date in Excel, use =EDATE(A2,3), assuming the starting date is in cell A2. EDATE returns…
- Excel Date Plus 1 Month: Formula and Month-End RulesTo add one calendar month to a date in Excel, use the EDATE function: if the starting date is in A2, enter…
- Excel Date Plus Weeks: Formulas, Dates, and ExamplesTo add weeks to a date in Excel, multiply the number of weeks by 7 and add the result to the date:…
- Excel Date Minus Days: Formulas and ExamplesTo subtract calendar days from a date in Excel, subtract a number from the date cell: if the date is in A2,…
- Excel Date Minus Months: Formulas and ExamplesTo subtract calendar months from a date in Excel, use EDATE with a negative month count. If the starting date is in…
- Excel Date Math: Formulas, Serial Numbers, and ExamplesExcel date math works by treating dates as numbers: subtract one date from another to count elapsed days, add a number to…
- Excel Date Minus 1 Month? Formula and Date RulesTo subtract one calendar month from an Excel date, use =EDATE(A1,-1), where A1 contains a real Excel date. EDATE keeps the day…
- Excel Date Minus 1 Year: Formula and Leap-Year RulesTo subtract one calendar year from a date in Excel, use =EDATE(A2,-12), assuming the original date is in A2. EDATE moves the…
- Excel Date Countdown Formula: Calculate Days Left in ExcelIf the target date is in cell B2, enter =B2-TODAY() in another cell to show the number of days remaining. A future…
- Excel Date Count Formula: Count Days and DatesIf your dates are real Excel date values in A2:A100, use =COUNT(A2:A100) to count the cells containing dates. If you mean the…
- Excel Date and Time: Formatting, Formulas, and FixesExcel stores dates as serial numbers and times as fractions of a day, so you can format them for display and use…
- Excel Table Sort by Two Columns: A Step-by-Step GuideTo sort an Excel table by two columns in Microsoft 365 for Windows, click a cell in the table, choose Data >…
- Excel Table Query: How to Filter, Transform, and Refresh DataIn Excel for Microsoft 365 on Windows, the usual way to query an Excel table is to select a cell in it…