Enter Month and Day to Add the Current Year in Excel
Question details
Enter a month and day in Excel and display the date with the current year.

- 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.
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.
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.
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.
Select the date cell and open the Format Cells dialog, for example by pressing Ctrl+1 in Excel for Windows.
On the Number tab, select Custom, enter m/d/yyyy in the Type box, and select OK.

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. Open a spreadsheet: Open WPS Spreadsheet and create a workbook or open an existing Excel file.
- 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. Format the date: Select the cell, open Format Cells, and choose Custom under the Number settings.
- 4. Display the year: Enter m/d/yyyy as the custom format and confirm the change.

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.




