How not allow entry of weekend dates or holiday dates

Unless I misread the question this should help you:
http://office.microsoft.com/en-us/excel-help/designate-valid-cell-entries-HP005202210.aspx

Although I found this somewhat helpful it didn't really provide a solution to my question unless I'm missing something.

there is another excel question regarding date restriction in this portal:
https://www.experts-exchange.com/questions/25784324/Restrict-cell-entry-by-date-and-add-a-message.html

you can download the sample excel file and change the code to suits your date selection needs.

Which version of Excel are you using, Steve?

If you have Excel 2007 or later you can use data validation - Assuming you want to restrict cell E2 to workdays choose "custom" option and enter this formula

=WORKDAY(E2+1,-1,Holidays)=E2

If the cell is currently empty you'll get a warning that the formula evaluates to an error - that's OK, you can ignore that.

It's possible in earlier versions but you'll need a more complex formula.....

regards, barry

Actually McOz, I got the same thing - couldn't make it work with the named range but it works with a specific range as long as that range is on the same sheet, e.g.

=WORKDAY(E2+1,-1,H$1:H$10)=E2

where holidays are in H1:H10

In Excel 2003 or earlier you can use this version

=AND(WEEKDAY(E2,2)<6,COUNTIF(H$1:H$10,E2)=0)

If you have the holiday range on another sheet you can make it work with INDIRECT function, e.g. if holidays are in H1:H10 on a different sheet [sheet2] you can use this version

=AND(WEEKDAY(E2,2)<6,COUNTIF(INDIRECT("Sheet2!H1:H10"),E2)=0)

regards, barry