Calculate End Date (excluding weekends and holidays)
The WORKDAY function requires the Analysis ToolPak add-in to be loaded.
Click Tools/Add-Ins from Excel's menu bar and put a check mark next to the
Analysis ToolPak item.
--
Rick (MVP - Excel)
"guitaronmyback" wrote in message
...
Thank you for the tip, but I got the #name? as a result
"Mike H" wrote:
Hi,
Try this
=WORKDAY(B1,25,Holidays)
Where
B1=start date
25 is the days for the project
Holidays is a named range containing holoiday dates.
Mike
"guitaronmyback" wrote:
Hello,
I have a start days and a number (representing days for a given
project). I
want to calculate the end date and exclude weekends and certain
holidays.
Is this possible?
Thank you
|