View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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



.