validate a date range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 :)
 
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
 
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
:)
 
Glad to hear that. This closes your orig. query.

Suggest you put in a new posting for your new query
 
Back
Top