Hi!

Use the Workday function (requires the Analysis ToolPak be installed). It
includes an argument that accounts for holidays.

Instead of entering day n, just enter the n:

4/20/06 task 1 1
formula task 2 2
formula task 3 2
formula task 4 3

The formula would be:

=WORKDAY(A$1,C2,J$1:J$5)

Copied down as needed.

J$1:J$5 would be the list of holiday dates that you want to exclude.

Biff

"JP" wrote in message
...
I have a running schedule with mutlile tasks scheduled for different day #
or
the same and would like to have the dates auto fill in once I enter the
start
date.
example:
4/20/06 task 1 day 1
? task 2 day 2
? task 3 day 2
? task 4 day 3

Keeping in mind that I don't want to include weekends and that I'll need
to
delete a range of holiday dates.

Please help. Thank you