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

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

 

[Venkat]

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

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

Thanks
Venkat

 

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

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

 

[Jim Johnson]

Thanks Venkat and Ron for your help.