Formulas & functions
How a function works, with worked examples you can paste.
- Excel Formula for Current Time: NOW, TIME, and UpdatesTo show the current date and time in Excel, enter =NOW(). To show only the time, use the same formula and apply…
- Excel Formula for Age at a Certain Date Using DATEDIFTo calculate someone’s age on a particular date in Excel, use =DATEDIF(A2,B2,"Y"), where A2 contains the birth date and B2 contains the…
- Excel Formula for Age From Date of BirthThe simplest Excel formula for age from a date of birth is =DATEDIF(A2,TODAY(),"Y"), assuming the birth date is in cell A2. It…
- Excel Formula for Age From DOB: Years, Months, and DaysTo calculate age in completed years from a date of birth in cell A2, use =DATEDIF(A2,TODAY(),"Y"). It compares the birth date with…
- Excel Formula for Years Between Dates: Exact or DecimalFor completed years between two dates in Microsoft Excel, enter a start date in A2 and an end date in B2, then…
- Excel Formula: Years, Months, and Days Between DatesTo calculate complete years, months, and remaining days between dates in Excel, use DATEDIF for the years and months, then subtract the…
- Excel Formula to Calculate Days Between Dates, ExplainedTo calculate elapsed days between two dates in Excel, subtract the earlier date from the later one. With a start date in…
- Excel Formula to Reference a Sheet Name from a CellTo reference a worksheet named in a cell, use Excel’s INDIRECT function. If A1 contains the sheet name and you want the…
- Excel Percentage Difference Formula: How to CalculateFor the percentage difference between two nonnegative values in Excel, use =ABS(B2-A2)/AVERAGE(A2,B2), then format the result as a percentage. This symmetric calculation…
- Excel Formula for Percentage of a NumberTo calculate a percentage of a number in Excel, multiply the number by the percentage: if A2 contains 150 and B2 contains…
- Excel Formula: Keep a Cell Fixed When You Copy ItTo keep a cell reference fixed when copying an Excel formula, add dollar signs to it: with a value in A2 and…
- Excel Date Difference Formulas for Days, Months, and YearsTo find the number of elapsed days between two dates in Excel, subtract the start date from the end date: if the…
- Excel Formula for Number of Days Between Two DatesTo find the number of days between two dates in Excel, subtract the earlier date from the later one: enter =B2-A2 when…
- Excel Formula Bar Disappeared? How to Show It AgainIf the Excel formula bar disappeared, turn it back on from View > Show > Formula Bar in Excel for Microsoft 365…
- Excel Formula Between Two Dates: Count, Sum, or CheckIf dates are in A2:A100, the start date is in D1, and the end date is in E1, count dates within that…
- Excel Shortcut to Drag a Formula DownIn Excel for Microsoft 365 on Windows, select the cell with the formula and the cells below it, then press Ctrl+D to…
- Excel Shortcut to Pull Down a Formula: Fill Down FastIn Excel for Microsoft 365 on Windows, select the formula cell and the cells below where you want it copied, then press…
- Excel Shortcut to Paste a Formula: Keys and Tips in ExcelIn Excel for Microsoft 365 on Windows, copy the formula cell, select the destination, then press Ctrl+Alt+V, press F, and press Enter…
- Copy Formula in Excel Without Dragging: 6 WaysTo copy a formula in Excel without dragging, copy and paste it, use Ctrl+D to fill down, or use Home > Fill…
- How to Copy a Formula in Excel to Other Cells SafelyTo copy a formula in Excel, select the cell that contains it, then drag its fill handle into the cells you want…
- How to Copy a Formula Horizontally in ExcelTo copy a formula horizontally in Excel, select the cell that contains it and drag the small fill handle at the cell’s…
- Copy a Formula in Excel: Keyboard ShortcutsTo copy a formula in Excel on Windows, select its cell and press Ctrl+C, select the destination cell or range, then press…
- How to Copy a Formula Across an Entire Row in ExcelTo copy a formula across a row in Excel, enter it in the leftmost cell, select that cell and the cells to…
- How to Copy a Formula in Excel Across Multiple RowsTo copy a formula down rows in Excel, enter it in the first cell, then drag the fill handle downward or select…
- How to Copy a Formula Down an Entire Column in ExcelTo copy a formula down a column in Excel, enter it in the first cell, select that cell and the cells below…
- How to Copy Formula Data in Excel Without Breaking ReferencesTo copy formula data in Excel, select the cells, press Ctrl+C, choose the destination, and use Home > Paste to select Formulas,…
- How to Copy a Formula in Excel All the Way Down a ColumnTo copy a formula all the way down in Excel, select the cell with the formula and double-click its fill handle, the…
- How to Add a Formula in an Excel Text Box That UpdatesTo show a formula result in an Excel text box, enter the calculation in a worksheet cell, select the text box border,…
- How to Remove Spaces in Excel With TRIM and SUBSTITUTETo clean extra spaces in Excel, use TRIM; to delete every ordinary space, use SUBSTITUTE. With the original text in A2, enter…
- Calculate Age in Excel as of Today: Formulas That WorkTo calculate age in completed years as of today, put each person’s date of birth in A2 and enter =DATEDIF(A2,TODAY(),"Y") in another…