Validate a cell - Workdays only

  • Thread starter Thread starter Rory
  • Start date Start date
R

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.
 
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
 
Go into Data > Validation. Under Allow: Custom. Now
insert:

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

HTH
Jason
Atlanta, GA
 
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





.
Click to expand...
 
Back
Top