Fill Weekdays-Skip Holidays

  • Thread starter Thread starter Shadow
  • Start date Start date
S

Shadow

How do you automatically fill in weekdays (date and day),
but skip the holiday date and day.
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Working out a future date with formulas 3
Calculate Project dates 2
Skip the holidays 6
Excel 2003 - define name like a filtered list 1
Skip the Holidays 2 9
Working Days function copied down column 1
Holiday rules for Memorial Day Dates 18

Back
Top