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?

Who is Participating?
barry houdiniConnect With a Mentor Commented:
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!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.