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

  • Thread starter Thread starter jjhacke
  • Start date Start date
J

jjhacke

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")
 
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.
 
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")
Click to expand...

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
 
Back
Top