validate a date range

[tikchye_oldLearner57]

hi community

any help from community to solve this task...

To validate a cell range that only accept date from Monday to Friday and
reject Saturday and Sunday in any date format.

Example:

If an user enter a date 03/17/2007 (is Saturday date in March), the cell
will reject entry.

If an user enter a date 06/24/2007 (is Sunday date in June), the cell will
again reject entry

community, can this sort of validation be accomplish in Excel ?

thanks community for the assistance and much appreciated

 

[Max]

One way ..

Assume dates will be entered in A1 down

Select col A
Click Data > Validation
Allow: Custom
Formula is:
=WEEKDAY(A1,2)<6
Click OK

 

[tikchye_oldLearner57]

thanks "Max" yes! it works, much appreciated

just curious...

how can improvise the syntax to say the following:...??

to avoid even days or odd days and odd n even, example...

like every Monday and Thursday or perhaps Wednesday and Friday ?

thanks Max and Community as well for the kind assistance, much appreciated

 

[Max]

Glad to hear that. This closes your orig. query.

Suggest you put in a new posting for your new query

 

[tikchye_oldLearner57]

ok will do

thanks again to all
--
oldLearner57

Glad to hear that. This closes your orig. query.

Suggest you put in a new posting for your new query