I have a problem for creating appointment schedule. For example,with a given
date No 1, say 24 Nov 06. The criteria is I cannot make appointment 5
working days before 24 Nov06 and 2 workdays after.
A2 = (date before); B2 = (Given Date No. 1); C3 = (Date after Given)
A2 B2 C2
=B2-5 B2+2
19.11.06 24.11.06 26.11.06

However,A2 - 19.11.06 fall on a sunday, the date should be 17.11.06 to
exclude saturday and sunday. Similar for C2 - 26.11.06 (Date for Appointment
should be after 28.11.06. Please help