validate a date range

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 :)
 
G

Guest

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
 
G

Guest

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
:)
 
G

Guest

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

Suggest you put in a new posting for your new query
 
G

Guest

ok will do

thanks again to all
--
oldLearner57


Max said:
Glad to hear that. This closes your orig. query.

Suggest you put in a new posting for your new query
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

validate alternate day date 7
category axis - date 2
adding days from one cell with a date in it to another cell 3
If C2 is Sunday how do I make D 2 to the next day of the week 2
display the day of the date 3
Date Questions 1
Date plus month, year, or years in workdays 5
Date Range 6

Top