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