How do I ensure dates inputted are during the work week?

J

Jim Johnson

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).
 
V

Venkat

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

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

Thanks
Venkat
 
R

Ron Rosenfeld

On Thu, 28 Oct 2004 15:29:05 -0700, "Jim Johnson" <Jim
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).
Click to expand...

Are these dates that are entered or dates that are calculated.

If they are dates that are manually entered, then select the range in which
these dates might be entered.

Assume A3:A1000

A3 is now the active cell.

From the main menu bar:

Data/Validation/Settings
Allow: Custom
Formula: =WEEKDAY(A3,3)<5

and put appropriate messages for the Input Message and Error Alert.

If they are calculated, please supply more data.


--ron
 
Top