Excel Date Formatting not allowing 2022

New Contributor

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.

6 Replies

@Jen3505 perhaps you may provide sample file?

best response confirmed by Jen3505 (New Contributor)


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



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

@Sergei Baklan Thank you, much appreciated! 

@Jen3505 , you are welcome