View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Fool on the Hill The Fool on the Hill is offline
external usenet poster
 
Posts: 58
Default 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?