Return Working Day 1 and so on

[Carmen]

Hello,

I am attempting to set up a calendar that is generic by working day labeled
1..2..3, etc. That part is easy enough, however below the working day
number, I would like excel to calculate the corresponding date that goes with
each work day for each month through the end of the year, excluding holidays.
Our work days are Monday through Friday.

Ideas?

Thanks!
Carmen

 

[T. Valko]

One way...

H1 = first date of the year = 1/1/2008

J1:J10 = list of holiday dates

Enter this formula in A1 and copy down as needed:

=WORKDAY(H$1,ROWS(A$1:A1)-(H$1<>J$1),J$1:J$5)

Format as DATE

The WORKDAY function requires the Analysis ToolPak add-in be installed on
versions of Excel prior to Excel 2007.

See Excel help on the WORKDAY function if you get #NAME? errors.