Excel Date Formatting not allowing 2022

[Jen3505]

Hi Everyone,

I have a project tracker in excel with the date column formatted to show MM/DD/YYYY but when I add dates for 2022 I get a validation error or it auto corrects everything to 2021.

[#2]

@Jen3505 perhaps you may provide sample file?

[#3]

Here is an example:
https://www.dropbox.com/s/2yq4h5lxm17otv9/Sample%20Tracker%202022.xlsx?dl=0

[#4 · Accepted solution]

@Jen3505 

Please select cells in Bid Date column, on ribbon Data-Data validation. Here you my change limits for all or some cells

In attached file I changed only for this cell

[#5]

@Jen3505 

Forgot to say, you may apply any format to the resulting date, that doesn't matter.

[#6]

@Sergei Baklan Thank you, much appreciated! 

[#7]

@Jen3505 , you are welcome