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

ie.

july 1 2006
15
july 21 2006

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


"tom" wrote:

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

ie.

july 1 2006
15
july 21 2006

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

"Ron Coderre" wrote:

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


"tom" wrote:

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

ie.

july 1 2006
15
july 21 2006

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


"tom" wrote:

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

"Ron Coderre" wrote:

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


"tom" wrote:

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

ie.

july 1 2006
15
july 21 2006