Dates only in columns

[ttowncorp]

is it possible to lock specific column to only input dates. 1/1/2024? I was trying to lock column A2 and down to only be able to type in mm/dd/yr. and b2 and down same thing but you can only input current dates and past dates. I don't want it to allow people to input future dates like 12/15/2024.

 

[Sergius]

In order to enter dates according to your conditions:
select the range, then on the ribbon select Data > Data Validation, select “Date” from the list, and select “Less than or equal” from the list below. After that, in the “End date” line, enter the following formula:

=TODAY()

 

[ttowncorp]

In order to enter dates according to your conditions:
select the range, then on the ribbon select Data > Data Validation, select “Date” from the list, and select “Less than or equal” from the list below. After that, in the “End date” line, enter the following formula:

=TODAY()

thanks.