How to calculate with workingdays instead of calendar days
Dear excel(lent) users,
I have a sheet in which I calculate with days.
I want to know how to calculate with working days.
For instance if you take today 17th of november and you add 6 workingdays,
you would calculate it to be 24th of november instead of 22nd of november
with calendar calculation.
Can someone help me with the following:
If I have a certain date what date would I get if I add up 5 working days
(weekend not being a working day)?
Please be so kind as to assist me with this?
|