SOLVED

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)
Solution

@Jen3505 

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

image.png

In attached file I changed only for this cell

image.png

@Jen3505 

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