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
LVL 6
KnutsonBMAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
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
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.