Forum Discussion
Data validation date format across different computers
I have data validation limiting input to dd/mm/yy (e.g. 18/06/20). The cell displays as dddd, mmmm dd, yyyy (Thursday, June 18, 2020). The problem is that other staff, when editing this spreadsh...
Thanks Sergei,
I guess that is my question. I followed instructions for restricting the date format, but it isn’t working. So I am asking what else I need to do.
I guess that is my question. I followed instructions for restricting the date format, but it isn’t working. So I am asking what else I need to do.
Afraid format won't help. If the user types 05/06/20 it could be May or June depends on format, but we may validate only value. For example, it shall be current month, i.e. June and current year, i.e. 2020 - with such logic we may validate the date.