Formatting Issues

Enter Month and Day to Add the Current Year in Excel

Khadija KhanKhadija Khan Nov 18, 2026 870 views

Question details

Enter a month and day in Excel and display the date with the current year.

Enter Month and Day to Add the Current Year in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to type a short date such as 01/27 without entering the year.
Observed behavior
Excel should recognize the entry as a date, assign the current year, and display that year when a suitable date format is applied.
Before you start

Check that the cell is not formatted as Text and that your regional date settings recognize the month-and-day order you plan to enter.

Solution 1Recommended

Enter a Month and Day and Format the Date in Excel

Use Excel's default date parsing to assign the current year, then show it with a custom format.

1
Enter the date

Select a cell, type 01/27 or 1/27, and press Enter. Excel normally assigns the current year when it recognizes the entry as a date.

2
Open cell formatting

Select the date cell and open the Format Cells dialog, for example by pressing Ctrl+1 in Excel for Windows.

3
Show the year

On the Number tab, select Custom, enter m/d/yyyy in the Type box, and select OK.

Enter a Month and Day and Format the Date in Excel
The year is fixed when entered: Excel assigns the current year when you enter the date; it does not automatically update that year in subsequent years. Typing 127 without a date separator may be treated as a number.
Enter dates in WPS Spreadsheet

Add the Current Year to Dates in WPS Spreadsheet

Enter a month and day in WPS Spreadsheet and apply a custom date format to display the year assigned to the date.

  1. 1. Open a spreadsheet: Open WPS Spreadsheet and create a workbook or open an existing Excel file.
  2. 2. Enter the date: Select a cell, type a month and day such as 1/27, and press Enter. When WPS recognizes it as a date, it normally assigns the current year.
  3. 3. Format the date: Select the cell, open Format Cells, and choose Custom under the Number settings.
  4. 4. Display the year: Enter m/d/yyyy as the custom format and confirm the change.
Enter a short month-and-day date without typing the yearDisplay the year with a custom date formatOpen and save Microsoft Excel XLSX filesUse familiar spreadsheet formatting tools
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show only the month and day after I enter a date?

The cell's date format may hide the year. Select the cell, open Format Cells, and choose Custom with the format m/d/yyyy to display it.

Will the year change automatically next January?

No. Excel assigns a year when it interprets the entry as a date, and that stored year remains fixed unless you change the date or use a formula.

Why does typing 127 not create a January 27 date?

Excel may interpret 127 as a number. Enter a date separator, such as 1/27, using the order recognized by your regional settings.

What if Excel treats 1/27 as text?

Check your regional date settings and enter the date in the expected order. Also change the cell from Text to General in Format Cells, then re-enter the date.