Solved

# Formula to drag accross and show just Workdays

Posted on 2011-10-21
195 Views
Is there a way to write the workday formula so i can put it in one cell and drag it to the right and only populate only workdays?

-Brandon
0
Question by:KnutsonBM

LVL 50

Accepted Solution

If you have start date in A2 put this formula in B2 and copy across

=WORKDAY(A2,1)

If you want to exclude holidays too then you can include that range, e.g. with holidays in Z4:Z20

=WORKDAY(A2,1,\$Z4:\$Z20)

rg=egards, barry

0

LVL 6

Author Comment

aaaaaaaaah, i was looking at that (because i had done it before), went back to my spreadsheet and figured out my automatic calculation was turned off, thanks!

-Brandon
0

## Featured Post

### Suggested Solutions

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…