counting function with weekdays only

[LSG]

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

Can anyone help?

 

[T. Valko]

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.

 

[Mike H]

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]

It works perfect! Thanks!
--
-Liz

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]

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

 

[T. Valko]

You're welcome. Thanks for the feedback!