View Single Post
  #4   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

Thanks super answer.

I see it starts counting on the today+1 instead including today, but I can
work around that.

I am a happy chappy !

Thankx !

"John C" wrote:

Take a look at WORKDAYS function. Ensure your Analysis ToolPak Add-in is
installed.
=WORKDAY(startdate,days,holidays)
Holidays is an optional argument. If you have a list of all the holidays,
and you refer to the list of holidays here, it will also not count holidays
as workdays.
--
** John C **


"The Fool on the Hill" wrote:

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?