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")