Validate a cell - Workdays only

[Rory]

Hopefully this should be fairly easy - I have a cell on a
worksheet that a user enters a date into, but I need to
set it so only a workday can be entered.

 

[Chip Pearson]

Rory,

Select the cell in question and go to the Data menu and choose
Validation. There, select 'Custom' from the Allow list, and enter
the following formula:

=NOT(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7))

Change the A1 reference to the cell in question.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Frank Kabel]

Hi
in the data validation dialog use a custom formula like
=WEEKDAY(A1,2)<6

 

[Jason Morin]

Go into Data > Validation. Under Allow: Custom. Now
insert:

=AND(TEXT(A1,"ddd")<>"Sun",TEXT(A1,"ddd")<>"Sat")

HTH
Jason
Atlanta, GA

 

[Rory]

Thanks

-----Original Message-----
Rory,

Select the cell in question and go to the Data menu and choose
Validation. There, select 'Custom' from the Allow list, and enter
the following formula:

=NOT(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7))

Change the A1 reference to the cell in question.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





.