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?
|