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...
Data validation could be applied if some formal logic is in place. I don't see it here, how do we know 5th June or 6th May is correct date?
- 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.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.
