Issue with date not defaulting to 2023

[RazzelDazel]

Having an issue where if I type just the month and day, it will not default to the current year. Example:

Type Jan 6 <enter> it comes out as January 1, 2006
Type Feb 28 <enter> it comes out as February 1, 2028

I am positive that regardless of the month or day entered, the year would automatically default to 2023.

What am I missing here?

 

[etaf]

mine does not work - give 2006

Dynamic Column Color Change according to Nearest Above and Low value -ETAF.xlsx
	L	M
8
9	Jan-06	2006-01-01
10	1-Feb	2001-02-01
Sheet1

Cell Formulas
Range	Formula
M9:M10	M9	=L9

i type in
in UK DD/MM

6/1
28/2
then it works

Dynamic Column Color Change according to Nearest Above and Low value -ETAF.xlsx
	L	M
9	Jan-06	2006-01-01
10	1-Feb	2001-02-01
11
12	6-Jan	2023-01-06
13	28-Feb	2023-02-28
Sheet1

Cell Formulas
Range	Formula
M9:M10,M12:M13	M9	=L9

 

[RobP]

Hi, that's Excels standard way - its not just you.

Try typing 6 Feb instead ?

Rgds
Rob