| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple formula
cheers
"Bob Phillips" wrote: This should so what you want =WORKDAY(IF(ISNUMBER(A1),A1,A2),2,holidays) where holidays is a range of holiday dates -- __________________________________ HTH Bob "Paul" wrote in message ... Yes and bank holidays. The formula in A3 currently as shown works great for data in A1 ,I just dont know how I can add =IF(WEEKDAY(A2+2)=1,A2+5,IF(WEEKDAY(A2+2)=7,A1+6,A 2+2)) into A3 also. "Bob Phillips" wrote: Aren't you trying to bypass weekend with the new date as well? -- __________________________________ HTH Bob "Paul" wrote in message ... THanks Bob, Looking at my question I dont think I was clear. I need to add 3 days if A1 is populated so my formula works however sometimes A1 will be blank and A2 will be populated with a date. A3 need to pick up either not both as this will never happen "Bob Phillips" wrote: =A1+3+(WEEKDAY(A1+3)=1)+(WEEKDAY(A1+3)=7)*2 -- __________________________________ HTH Bob "Paul" wrote in message ... Hi All, I have to provide a date for 2 variables A1 will need 3 days added and A2 needs 2 days added I have entered into A3 the following but need the formula for the 2 days also in A3....I'm stuck =IF(WEEKDAY(A1+3)=1,A1+5,IF(WEEKDAY(A1+3)=7,A1+6,A 1+3)) cheers Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to add multiple lines with multiple meanings | Excel Discussion (Misc queries) | |||
| Formula to sum multiple columns on multiple criteria | Excel Discussion (Misc queries) | |||
| multiple formula | Excel Discussion (Misc queries) | |||
| Multiple IF formula | Excel Discussion (Misc queries) | |||
| Multiple IF formula | Excel Discussion (Misc queries) | |||
Threaded Mode
