On Wed, 08 Dec 2004 17:40:20 -0500, Ron Rosenfeld
wrote:

On Wed, 08 Dec 2004 07:43:31 -0500, StargateFan
wrote:

And the 3 week code is:
=IF(B3<"",SUM(B3-21),"")

=IF(B3<"",workday(B3-20,-1),"")



And the 1 week code is:
=IF(B3<"",SUM(B3-7),"")


=IF(B3<"",workday(B3-6,-1),"")

If the WORKDAY function is not available, and returns the #NAME? error, install

I did get that error. <g

and load the Analysis ToolPak add-in.

Thanks, I'll look for it. I wouldn't be able to do that at work, as
you can imagine, as I can't install anything but it'll be a good
add-in to have here at home.

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.


--ron

Thank you!