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