how do i create a formula to give a workday date?
 

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(H280,H28+14,"TBD")

how do i create a formula to give a workday date?
 

Hi,

Try this

=IF(H280,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(H280,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(H280,H28+14,"TBD")

how do i create a formula to give a workday date?
 

On Fri, 19 Mar 2010 06:05:01 -0700, 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(H280,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(H280,workday(H28+13,1),"TBD")

If the latter:

=IF(H280,workday(H28,14),"TBD")

If you get a NAME error, see HELP for the WORKDAY function.
--ron