Do you have a range named holidays where you put public holidays?


--


Regards,


Peo Sjoblom

"gafern" wrote in message
...
Ron:

Thank you for sharing your knowledge.

I'm running Excel 2003 on Windows XP. I've followed the steps you
described
in this earlier thread, using the =WORKDAY formula. Cell A4 contains my
original date and has a date format. Cell B3 has the number 10 (for the
number of workdays) and is general format (I've also tried number format).
The formula of =WORKDAY(A4+B3-1,1,holidays) is in cell B4 and that had a
date
format as well. I am getting the #NAME? error. I have the Analysis
ToolPak
add-in showing in Tools.

Can you think of something I may be doing wrong?

Thanks, in advance, for your consideration.

GAF

"Ron Rosenfeld" wrote:

On Thu, 8 Feb 2007 13:44:00 -0800, Dolt
wrote:

I don't know understand why it works but it does
Thanks


You're welcome.

How it works:

1. Take original date
2. Add one less than the required number of days
3. Then add one Workday.

If adding one workday results in a weekend day or holiday, the Workday
function
will skip over that.


--ron