Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DATE WORKDAY PROBLEM | Excel Discussion (Misc queries) | |||
formula to look at current date and markdown date to give price | Excel Discussion (Misc queries) | |||
Formula to give date and time | Excel Worksheet Functions | |||
workday date function | Excel Worksheet Functions | |||
Trying to create formula to give range of stan.deviations of mean | Excel Discussion (Misc queries) |