Return Working Day 1 and so on
 

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

Return Working Day 1 and so on
 

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.


--
Biff
Microsoft Excel MVP


"Carmen" wrote in message
...
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