Dec 13 2021 08:50 AM
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.
Dec 13 2021 09:28 AM
@Jen3505 perhaps you may provide sample file?
Dec 13 2021 09:43 AM
Dec 13 2021 11:55 AM
SolutionPlease 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
Dec 13 2021 11:56 AM
Forgot to say, you may apply any format to the resulting date, that doesn't matter.
Dec 13 2021 12:16 PM
@Sergei Baklan Thank you, much appreciated!
Dec 13 2021 11:55 AM
SolutionPlease 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