Prev: a Counting question
Next: Two digit number with one decimal, or three digit number
From: jjhacke on 19 Mar 2010 09:05
I am trying to set up a worksheet the gives me a date during the work week
that is 5 work days, 10 workdays, etc from the date that is entered.

I also want the cells to result in TBD until the first date is input.

Here is an example of the formula I created that gives me TBD but not a
workday date.

=IF(H28>0,H28+14,"TBD")
From: Mike H on 19 Mar 2010 09:10
Hi,

Try this

=IF(H28>0,WORKDAY(H28,14),"TBD")

Note the workday formula will take a third argument that is a range that
contains and holiday dates you want to exclude

=IF(H28>0,WORKDAY(H28,14,A1:A10),"TBD")

A1:a10 can contain holiday dates
--
Mike

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


"jjhacke" wrote:

> I am trying to set up a worksheet the gives me a date during the work week
> that is 5 work days, 10 workdays, etc from the date that is entered.
>
> I also want the cells to result in TBD until the first date is input.
>
> Here is an example of the formula I created that gives me TBD but not a
> workday date.
>
> =IF(H28>0,H28+14,"TBD")
From: Ron Rosenfeld on 19 Mar 2010 12:18
On Fri, 19 Mar 2010 06:05:01 -0700, jjhacke <jjhacke(a)discussions.microsoft.com>
wrote:

>I am trying to set up a worksheet the gives me a date during the work week
>that is 5 work days, 10 workdays, etc from the date that is entered.
>
>I also want the cells to result in TBD until the first date is input.
>
>Here is an example of the formula I created that gives me TBD but not a
>workday date.
>
>=IF(H28>0,H28+14,"TBD")

The question is whether you want the first workday after h28+14, or do you want
to add 14 workdays to h28.

If the former:

=IF(H28>0,workday(H28+13,1),"TBD")

If the latter:

=IF(H28>0,workday(H28,14),"TBD")

If you get a NAME error, see HELP for the WORKDAY function.
--ron
 | 
Pages: 1
Prev: a Counting question
Next: Two digit number with one decimal, or three digit number