Say you have input dates in column A, Have following formula in some other
column

=IF(WEEKDAY(A1,2)5,"WeekEnd","")

Thanks
Venkat

"Jim Johnson" wrote:

I have a spreadsheet at work that we use to track shipments and would like
to use some kind of validation feature that ensures all dates are during the
work week (no weekend deliveries).