validate a date range
 

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


--
oldLearner57

validate a date range
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"tikchye_oldLearner57" wrote:
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 :)


--
oldLearner57

validate a date range
 

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

--
oldLearner57


"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"tikchye_oldLearner57" wrote:
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 :)


--
oldLearner57

validate a date range
 

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

Suggest you put in a new posting for your new query
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"tikchye_oldLearner57" wrote:
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
:)
--
oldLearner57

validate a date range
 

ok will do

thanks again to all
--
oldLearner57


"Max" wrote:

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

Suggest you put in a new posting for your new query
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"tikchye_oldLearner57" wrote:
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
:)
--
oldLearner57