If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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") |
#2
|
|||
|
|||
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") |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|