View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LSG LSG is offline
external usenet poster
 
Posts: 16
Default 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