• 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?

1 Solution
barry houdiniCommented:
If you have start date in A2 put this formula in B2 and copy across


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


rg=egards, barry

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!


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