Formulas & functions
How a function works, with worked examples you can paste.
- Excel Days Until Due: Formula, Date Math, and Alerts ExplainedTo calculate days until a due date in Excel, put the due date in A2 and enter =A2-TODAY() in B2. The result…
- Monthly Excel Budget Spreadsheet: Setup and FormulasTo make a monthly Excel budget spreadsheet, list spending categories in column A, planned amounts in column B, actual amounts in column…
- Excel Days Remaining: Formulas for Calendar and WorkdaysTo calculate calendar days remaining in Excel, put the deadline in A2 and enter =A2-TODAY() in another cell. The result is the…
- Month Excel Formula From Date: Number, Name, or DateTo get the month number from a date in Excel, use =MONTH(A2) when the date is in cell A2. The result is…
- Excel Year Quarter Formula: Get Year and Quarter from DatesWith a valid Excel date in A2, use =ROUNDUP(MONTH(A2)/3,0) to return its calendar quarter as a number from 1 to 4. To…
- Excel Weekday From Date: Formulas That WorkTo get the weekday for a date in Excel, use =WEEKDAY(A2,2) when the date is in cell A2; this returns 1 for…
- WEEKDAY Function in Excel: Find the Day of the WeekExcel’s WEEKDAY function returns a number for the day of the week represented by a date. If cell A2 contains a real…
- Excel WORKDAY Formula: Does It Exclude Weekends?Yes. In Microsoft Excel for Microsoft 365 on Windows, WORKDAY excludes Saturday and Sunday by default when it calculates a date a…
- EDATE in Excel: Add Months to a Date, With ExamplesTo add calendar months to a date in Excel, use =EDATE(start_date, months). For example, with a date in A2 and the number…
- EDATE in Excel: Add Months, Not DaysEDATE in Excel moves a date by whole calendar months; it does not add a specified number of days. If A2 contains…
- EDATE in Excel: How to Add Years to a Date CorrectlyExcel’s EDATE function adds months, not years. To add a whole number of years to a date in A2, with the number…
- Excel NOW Time: Current Time, Formulas, and ShortcutsTo display the current date and time in Excel, enter =NOW() in a cell; to show only the time, format that cell…
- Excel NOW Function Not Updating? Causes and FixesExcel’s NOW() function does update, but it does not run like a live clock: it returns the current date and time when…
- Excel Not Greater Than: How to Use the <= Operator in FormulasIn Excel, “not greater than” means less than or equal to, and the operator is <=. For example, a formula such as…
- Excel Not Blank Criteria: COUNTIF, SUMIF, and Practical ExamplesIn Excel, use the not-blank criterion "<>" in functions such as COUNTIF, COUNTIFS, SUMIF, and SUMIFS. For example, with entries in A2:A20,…
- Excel Extract Date from DateTime: Formulas and FixesTo extract the date from an Excel date-time value in cell A2, enter =INT(A2). The formula removes the time portion and returns…
- Excel: How Many Days Are in a Month? Formula GuideA month can have 28, 29, 30, or 31 days, so Excel needs a year and month—or a date within the month—to…
- Excel VLOOKUP: Find Data Across TablesIn Excel, VLOOKUP searches for a value in the leftmost column of a range and returns a value from another column in…
- Excel DATE Code: Formula, Examples, and Format CodesExcel’s date code is the DATE function, which creates a real date from a year, month, and day. With literal inputs of…
- Excel Data Sorting: Sort Rows, Columns, and Lists CorrectlyTo sort data in Excel for Microsoft 365 on Windows, click a cell in the column you want to sort, then choose…
- Excel TEXT Function Format Options and Examples ExplainedExcel’s TEXT function converts a number, date, or time into text displayed with a format code: use =TEXT(value, format_text). Its options include…
- Search Excel for Text: Find Cells and Match ContentTo search Excel for text, press Ctrl+F on Windows, type the word or phrase, then press Enter or choose Find All. Use…
- Replace Multiple Words in Excel: Methods and FormulasTo replace several different words in Excel, use Ctrl+H and run Find and Replace once for each word, or use a formula…
- Replace Text in Excel: Find, Replace, and FormulasTo replace text in Excel for Microsoft 365 on Windows, press Ctrl+H, enter the text to find and its replacement, then choose…
- TRIM in Excel for Text Cleanup: What It RemovesIn Excel for Microsoft 365 on Windows, use TRIM to remove ordinary spaces at the beginning and end of text and reduce…
- Trim Excel Data: Remove Extra Spaces the Right WayTo remove extra spaces in Excel, enter =TRIM(A2) in a helper column, replacing A2 with the cell you want to clean, then…
- Trim Excel Column Values and Remove Extra SpacesTo trim values in an Excel column, enter =TRIM(A2) in a blank column beside the first value, fill the formula down, then…
- How to Trim Excel Columns and Remove Extra SpacesTo trim extra spaces from text in an Excel column, enter =TRIM(A2) in a helper column, fill it down, then copy the…
- Excel Trim Decimal Places: Format or Change ValuesTo trim decimal places in Excel, select the cells and choose Home > Number > Decrease Decimal to change only how numbers…
- Excel Trim Empty Cells: Remove Blank Rows and ColumnsExcel has no single “trim empty cells” command. To remove blank cells from a selected range, select the range, choose Home >…