Skip to content
- Excel Not Letting You Type in a Cell? How to Fix ItIf Excel will not let you type in a cell, first check whether the worksheet is protected, the file is read-only, or…Errors & fixes
- Excel Not Making Graphs Correctly? Fix Common CausesIf Excel is not making graphs correctly, first check that the chart uses the intended data range, treats the first row or…Charts & pivot tables
- Excel Not Moving From Cell to Cell? Fixes That WorkIf Excel is not moving from cell to cell when you press the arrow keys, turn off Scroll Lock first: it makes…How-to basics
- Excel Day of Year: Find the Day Number for Any DateTo find the day of the year in Excel, put a real Excel date in A2 and enter =INT(A2)-DATE(YEAR(A2),1,0) in another cell.…How-to basics
- Excel Day Hour Minute Second Format: Display DurationsTo display an elapsed time in Excel as hours, minutes, and seconds, apply the custom number format [h]:mm:ss. The square brackets keep…How-to basics
- Excel Date Difference: Days, Workdays, and Inclusive CountsTo find the number of days between two dates in Excel, subtract the earlier date from the later one. With the start…How-to basics
- Excel Day Counter: Count Days Between DatesWith a start date in A2 and an end date in B2, enter =B2-A2 to count the days between them. For example,…How-to basics
- Excel Day Countdown: Build a Live Days-Left FormulaWith a deadline date in B2, enter =B2-TODAY() in C2 to show how many calendar days remain. For example, if today is…Formulas & functions
- Excel Day Care in Jurong East: Location, Fees and ChecksIf you’re looking for Excel Day Care in Jurong East, confirm that the specific centre is currently licensed and operating before making…How-to basics
- Excel Day Care in Clementi: Location and Enrolment GuideIf you are looking for Excel Day Care in Clementi, confirm the centre’s current address and operating status with Singapore’s Early Childhood…How-to basics
- Excel Day Based on Date: Find the WeekdayTo show the weekday for a date in Excel, enter =TEXT(A2,"dddd") in another cell, assuming A2 contains a valid Excel date; for…How-to basics
- Excel Day and Month Reversed? Fixing Date FormatsExcel usually does not swap the day and month in a date that is already stored correctly; a different date format can…How-to basics
- Excel Day and Date Formats: Codes, Examples, and FixesIn Excel for Microsoft 365 on Windows, a date’s day and date format controls how its value appears, not the underlying date…How-to basics
- YEAR Function in Excel Not Working? Fixes That HelpIf Excel’s YEAR function is not working, first check that its argument is a real Excel date, not text or a number…Errors & fixes
- Weekday Excel Shortcut: Formulas and Fast Ways to Get ItExcel has no dedicated keyboard shortcut that turns a selected date into its weekday. For a date in A2, use =TEXT(A2,"dddd") to…Formulas & functions
- Excel Weekday Name: Show the Day from Any Date in ExcelTo show the weekday name for a date in Excel, put the date in A2 and enter =TEXT(A2,"dddd") in another cell. If…How-to basics
- Excel WEEKDAY: Get the Day of the Week from a DateIn Excel, use WEEKDAY to return a number for the day of the week represented by a date. If A2 contains March…How-to basics
- Excel EDATE With Days Instead of Months: What to UseNo. EDATE adds months, not days; if A2 contains 10-Feb-2024 and B2 contains 30, use =A2+B2 to get 11-Mar-2024. For working days…Formulas & functions
- Excel NOW Shortcut: Insert the Current Date and TimeExcel has no dedicated keyboard shortcut that inserts the NOW() formula. To enter a fixed date and time, press Ctrl+;, then Space,…How-to basics
- Excel New Sheet Shortcut: Add a Worksheet in SecondsIn Excel for Microsoft 365 on Windows, press Shift+F11 to insert a new worksheet. The new sheet is placed immediately before the…How-to basics
- Excel New Row Shortcut: Insert Rows Above or BelowIn Excel for Microsoft 365 on Windows, select the row where you want the new one, then press Ctrl+Shift+= (the plus-sign shortcut)…How-to basics
- Excel New Sheet: How to Add and Open OneTo add a new worksheet in Excel for Microsoft 365 on Windows, click the plus sign beside the sheet tabs, or press…How-to basics
- Excel New Paragraph in Cell: Line Breaks ExplainedTo start a new paragraph inside an Excel cell in Microsoft 365 for Windows, edit the cell, place the cursor where the…How-to basics
- Excel New Line in Cell: Add Line Breaks and Fix ThemTo start a new line inside an Excel cell, edit the cell, place the cursor where the break should go, and press…Errors & fixes
- Excel New Blank Workbook: Create, Save, and Set It UpTo create a new blank workbook in Excel for Microsoft 365 on Windows, press Ctrl+N, or select File > New > Blank…How-to basics
- Excel New Note Shortcut: Add and Edit Notes QuicklyIn Excel for Microsoft 365 on Windows, select a cell and press Shift+F2 to create a new note; if the cell already…How-to basics
- Excel: How Many Complete Months Are Between Two Dates?To find the number of complete months between two dates in Excel, use =DATEDIF(A2,B2,"m"), with the earlier date in A2 and the…How-to basics
- Date Excel Shortcut: Insert Today’s DateIn Excel for Microsoft 365 on Windows, press Ctrl+; (semicolon) to insert today’s date as a fixed value in the selected cell.…How-to basics
- Excel: How Many Days Between Dates? Simple FormulasTo find how many days separate two dates in Excel, subtract the start date from the end date: with the start date…Formulas & functions
- Excel Date Conversion Methods for Text and Serial ValuesTo convert dates in Excel, first determine whether the cells contain real date serial numbers or text: format real dates with Home…How-to basics