Formulas & functions
How a function works, with worked examples you can paste.
- Excel COUNTIF Between Two Dates: Formula and ExamplesTo count dates in Excel between two boundary dates, use COUNTIFS, which applies both a start-date and an end-date condition to the…
- Excel Count Dates Older Than Today: Formula and FixesTo count dates in Excel that are earlier than today, use =COUNTIFS(A2:A100,"
- Excel COUNTIF for Numbers: Exact and Range MatchesYes. In Excel, use COUNTIF to count cells that match a number or a numeric condition: for example, with values in A2:A10,…
- Excel Count Dates Less Than Today with COUNTIF FormulaTo count dates in Excel that are strictly earlier than today, use =COUNTIF(A2:A100,"<"&TODAY()), replacing A2:A100 with your date range. TODAY updates automatically,…
- Excel Convert Text to Dates: Methods, Formulas, and FixesTo convert dates stored as text in Excel, select the cells and use Data > Text to Columns, then choose the date…
- Excel Conditional Formatting: Nested IFs for Dates?Yes. Excel conditional formatting can use a nested IF formula, but the formula must ultimately return TRUE or FALSE to decide whether…
- Excel Conditional Formatting for Dates: Rules and FormulasTo color dates in Excel, select the date cells, then choose Home > Conditional Formatting > Highlight Cells Rules > A Date…
- Excel Conditional Formatting: Color Cells With a FormulaYes. In Excel for Microsoft 365 on Windows, select the cells to format, then choose Home > Conditional Formatting > New Rule…
- Excel Conditional Formatting for Dates: Rules and FormulasTo conditionally format dates in Excel, select the date cells and choose Home > Conditional Formatting > Highlight Cells Rules > A…
- Excel Concatenate Dates Without Losing Their FormatExcel does not preserve a date cell’s display format when you concatenate it: the date may appear as a serial number or…
- Excel CONCATENATE: Does It Keep Text Formatting?No. Excel’s CONCATENATE, CONCAT, and TEXTJOIN functions combine values into text, but they do not preserve rich-text styling such as bolding or…
- Excel Concatenate Dates While Keeping Formatting in TextTo concatenate a date in Excel and keep its display format, convert the date to formatted text with TEXT before joining it…
- Excel Comparison Formulas: Functions and ExamplesExcel comparison formulas use operators such as =, <>, >, and <= to test values, usually returning TRUE or FALSE. To turn…
- Excel Compare Dates to Today: Formulas and ExamplesTo compare a date in Excel with today, use the TODAY() function: for a date in A2, =A2=TODAY() checks whether it is…
- Excel Combine Cells With Dates and Text: FormulasTo combine a date in A2 with text in B2, use =TEXT(A2,"mmmm d, yyyy")&" "&B2. If A2 contains June 15, 2026 and…
- Excel Formula Codes: A Practical Function ListExcel formula codes usually means formulas and the function names inside them: each formula begins with an equals sign, followed by a…
- Excel Cell Color by Hex: Apply, Match, and DisplayYes. In Excel for Microsoft 365, you can apply a cell fill that corresponds to a hex color, but a normal worksheet…
- Excel Cell Comparison Formula: Examples and MethodsTo compare two cells in Excel, enter =A2=B2 in another cell, assuming the values you want to compare are in A2 and…
- Excel Calculation for Hours Worked: Formulas and TipsFor a shift with start time in A2, end time in B2, and unpaid break duration in C2, enter =MOD(B2-A2,1)-C2 in D2…
- Excel Percent Change: Formula, Examples, and TipsTo calculate percent change in Excel, subtract the old value from the new value, then divide by the old value. If the…
- Excel Calculating Hours Worked: Formulas and TipsTo calculate hours worked in Excel, subtract the start time from the end time; for a shift that might pass midnight, use…
- Excel AVERAGEIF vs AVERAGEIFS: Rules and ExamplesUse AVERAGEIF when you need to average values that meet one condition; use AVERAGEIFS when every result must meet two or more…
- Excel AVERAGEIF With Dates: Formula, Examples, and TipsYes—Excel’s AVERAGEIF can average values for a matching date. With dates in A2:A100, values in B2:B100, and the date to match in…
- Excel Average Days Between Multiple Dates: Formulas and TipsWith dates in chronological order in A2:A6, calculate each gap in a helper column and average those gaps: in B3 enter =A3-A2,…
- Excel Average Days Between Dates: Formula and ExamplesTo average the number of days between paired dates in Excel, subtract each start date from its matching end date, then average…
- Excel Auto Fill Dates Based on a SequenceYes. In Excel for Microsoft 365 on Windows, enter a starting date and drag its fill handle down or across to continue…
- Excel: Assign Unique Numbers to Duplicate Values in RowsYes. In Excel for Microsoft 365 on Windows, you can number each repeated value by its occurrence with a running COUNTIF formula.…
- Excel Age from Date of Birth with DATEDIF ExplainedTo calculate age in completed years in Excel, put the date of birth in A2 and enter =DATEDIF(A2,TODAY(),"Y") in another cell. DATEDIF…
- Excel 2019 SUBSTITUTE Function: Syntax, Examples, and TipsExcel 2019 includes the SUBSTITUTE function for replacing specified text inside a cell with different text. Its syntax is =SUBSTITUTE(text, old_text, new_text,…
- VLOOKUP Errors in Excel: Causes, Checks, and FixesIf VLOOKUP returns an error, first check that the lookup value is in the leftmost column of the selected range and use…