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 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 questionNext: Two digit number with one decimal, or three digit number