Thread
:
How do I ensure dates inputted are during the work week?
View Single Post
#
3
Ron Rosenfeld
Posts: n/a
On Thu, 28 Oct 2004 15:29:05 -0700, "Jim Johnson" <Jim
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).
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
Reply With Quote