Lazy date entering help

Brass Contributor

Hello all,

 

I want to format a cell with the date where all I have to type in is the month and day and excel put the year in automatically.

 

So I would type in 127 or 0127 in the cell and excel would know to write it out as 1/27/2023.

 

Is that even possible?

 

You guys have been great, thank you for all the previous help.

1 Reply
just type in 01/27, excel will default the year to 2023