AutoFill

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using autofill to fill in weekdays, but i want it to exclude holidays.
is this possible?
 
If you have your start date in A1 then in A2 you can use the formula

=WORKDAY(A1,1,holidays) and copy down column, where holidays is a range
of cells containing your holiday dates

note: WORKDAY is part of Analysis ToolPak add-in
 

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

Autofill defaults 4
Autofill in 2007 10
Autofill 3
Is there a shortcut key for Auto Fill 3
Autofill: can it detect change in value? 3
HELP!!! I need macro to autofill 4
Question on Excel AutoFill command 1
Macro to autofill from a specific row to a specific row 2

Back
Top