Fill Weekdays-Skip Holidays

S

Shadow

How do you automatically fill in weekdays (date and day),
but skip the holiday date and day.
 
N

Norman Harker

Hi Shadow!

Enter your first date, which should be a weekday
Insert the holiday dates in a range of cells and name that range Hols.

Then the formula to use is:
=WORKDAY(A1,1,Hols)
Copy down to taste.

WORKDAY ia an Analysis ToolPak function so Analysis ToolPak must be
installed and selected as an Addin.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
S

Shadow

Hi Norman,

THANK YOU, THANK YOU, THANK YOU!!!! I'm still learning, but the info you were kind enought to share was enough to put me on the right track and get my brains working and I was able to complete this challenge.

----- Norman Harker wrote: -----

Hi Shadow!

Enter your first date, which should be a weekday
Insert the holiday dates in a range of cells and name that range Hols.

Then the formula to use is:
=WORKDAY(A1,1,Hols)
Copy down to taste.

WORKDAY ia an Analysis ToolPak function so Analysis ToolPak must be
installed and selected as an Addin.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top