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
|