• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

Formula to drag accross and show just Workdays

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
KnutsonBM
Asked:
KnutsonBM
1 Solution
 
barry houdiniCommented:
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
 
KnutsonBMAuthor Commented:
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now