Hello,

I am working with a template that will also have protection on the worksheet.

One of the columns of the table will be a date column. I would like to
enforce the user to use the format mm/dd/yy. If they do not, I would like
the user to be notified that they are not using an accepted format and I
would like the template to not accept the data entered.

I have tried to set the format values to the date field and I have protected
the worksheet but I can still enter in the date any way I want. I am using
Validation on other columns, can I use it here as well and how would I do
that on a date format?

Any help would be much appreciated.

Thanks