counting function with weekdays only
 

I need a formula to show this result : The 3rd business (weekdays only) day
after an application is taken.

Can anyone help?


--
-Liz

counting function with weekdays only
 

Try this...

A1 = some date

=WORKDAY(A1,3)

Format as Date

Note that the WORKDAY function requires the Analysis ToolPak add-in be
installed if you're using a version of Excel prior to Excel 2007. If you
enter the formula and get a #NAME? error look in Excel help for the WORKDAY
function. It'll tell you how to fix the problem.

--
Biff
Microsoft Excel MVP


"LSG" wrote in message
...
I need a formula to show this result : The 3rd business (weekdays only)
day
after an application is taken.

Can anyone help?


--
-Liz

counting function with weekdays only
 

Liz,

With your order date in a1 try this formatted as a date

=WORKDAY(A1,3)

Note the formula can take a third argument

=WORKDAY(A1,3,Holidays)

Where Holidays is a named range of holiday dates you want to ignore

Note the
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"LSG" wrote:

I need a formula to show this result : The 3rd business (weekdays only) day
after an application is taken.

Can anyone help?


--
-Liz

counting function with weekdays only
 

It works perfect! Thanks!
--
-Liz


"T. Valko" wrote:

Try this...

A1 = some date

=WORKDAY(A1,3)

Format as Date

Note that the WORKDAY function requires the Analysis ToolPak add-in be
installed if you're using a version of Excel prior to Excel 2007. If you
enter the formula and get a #NAME? error look in Excel help for the WORKDAY
function. It'll tell you how to fix the problem.

--
Biff
Microsoft Excel MVP


"LSG" wrote in message
...
I need a formula to show this result : The 3rd business (weekdays only)
day
after an application is taken.

Can anyone help?


--
-Liz


.

counting function with weekdays only
 

Didn't even think of the holidays. Thanks Mike!
--
-Liz


"Mike H" wrote:

Liz,

With your order date in a1 try this formatted as a date

=WORKDAY(A1,3)

Note the formula can take a third argument

=WORKDAY(A1,3,Holidays)

Where Holidays is a named range of holiday dates you want to ignore

Note the
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"LSG" wrote:

I need a formula to show this result : The 3rd business (weekdays only) day
after an application is taken.

Can anyone help?


--
-Liz

counting function with weekdays only
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"LSG" wrote in message
...
It works perfect! Thanks!
--
-Liz


"T. Valko" wrote:

Try this...

A1 = some date

=WORKDAY(A1,3)

Format as Date

Note that the WORKDAY function requires the Analysis ToolPak add-in be
installed if you're using a version of Excel prior to Excel 2007. If you
enter the formula and get a #NAME? error look in Excel help for the
WORKDAY
function. It'll tell you how to fix the problem.

--
Biff
Microsoft Excel MVP


"LSG" wrote in message
...
I need a formula to show this result : The 3rd business (weekdays only)
day
after an application is taken.

Can anyone help?


--
-Liz


.