work days function

T

tom

i wish to have a1=today() b1 = # and c1 return the working days forward.

ie.

july 1 2006
15
july 21 2006
 
R

Ron Coderre

Try this:

A1: (a date)
B1: (the number of workdays to increment A1 by)
C1: =WORKDAY(A1,B1)

Per Excel Help:
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
T

tom

that is the syntax that i used however it returns and error and corrects it
to work days(a1,b1) and returns and error of #rem
 
R

Ron Coderre

Hmmm...
First, make sure the Analysis TookPak is engaged:
<tools><add-ins>
Analysis TookPak should be checked.

If the ATP is active...check your auto-correct settings and see if they
automatically change "workday" to "work days"

<tools><options><spelling tab>
Click the [AutoCorrect Options...] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top