Use Data Validation, with the "list" option, and use

Monday,Tuesday,Wednesday,Thrusday,Friday

as your list. Check the "use in-cell dropdown" option for easy entering...

--
HTH,
Bernie
MS Excel MVP


"Systemgulv" wrote in message
...
I need a formula that only allow weekdays (monday to friday)
and not saturday and sunday in a cell.

You can write monday, but not saturday in the cell.

please help