Find end date

My brain is so very tired and I need help please.....

I need to calculate what the end date will be, minus workdays and holidays:
A1 - start date - 1/1/2007
B1 - 60 (days) - 60
C1 - end date - ???

I've tried everything I've read from the hundreds of Excel Help sites I've visited. I'm so very frustrated and would really appreciate any help.

Thank you in advance!

Hi

Do you mean minus weekends and holidays??? If you remove workdays and holidays, then what else is left???


rylo

Originally Posted by rylo

Hi

Do you mean minus weekends and holidays??? If you remove workdays and holidays, then what else is left???


rylo

Yes, I'm sorry - that is what I meant, minus weekends and holidays.

Try using the WORKDAY function from Analysis ToolPak add-in.

If you want to exclude holidays you'll need to list the dates, assuming you list holiday dates in Z1:Z10 you can use the formula

=WORKDAY(A1,B1,Z1:Z10)

Originally Posted by daddylonglegs

Try using the WORKDAY function from Analysis ToolPak add-in.

If you want to exclude holidays you'll need to list the dates, assuming you list holiday dates in Z1:Z10 you can use the formula

=WORKDAY(A1,B1,Z1:Z10)

I do have my list of Holiday dates. I changed your formula to match my cells.
I still get the error #NAME$.

You need to install Analysis ToolPak add-in

Go to Tools menu,select "Add-ins" and under that tick "Analysis ToolPak" box then re-type formula