Systemgulv said:
I meen entering weekday names in the cell.
vezerid skrev:
Data validation using a List that contains only Monday, Tuesday,..., Friday
would be one approach, but data validation doesn't prevent PASTING invalid
data into cells.
If you mean a formula validity check, to check the entry in cell A1 try
=ISNUMBER(MATCH(A1,{"Monday","Tuesday","Wednesday","Thursday","Friday"},0))
which will return TRUE if A1 contains a workday name and False otherwise.
You might want to be slightly more generous and use
=ISNUMBER(MATCH(TRIM(A1),
{"Monday","Tuesday","Wednesday","Thursday","Friday"},0))
which would allow arbitrary leading and trailing spaces.