ExcelBanter - work days function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - work days function (https://www.excelbanter.com/excel-worksheet-functions/100463-work-days-function.html)

work days function

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

ie.

july 1 2006
15
july 21 2006

work days function

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

work days function

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

work days function

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