Do you mean that weekday names (e.g. "Monday") will be entered in the
cell or dates (e.g. 6/22/2006) and you want to exclude weekend dates?

On Jun 22, 5:28 pm, Systemgulv
wrote:
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