Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula using work days
I am trying to set up a formula in excel based on an issue priority ranking
of emergency, high, medium and low. If an issue is of emergency priority, I want excel to add 2 workdays to the issues start date (which has already been defined in another cell). If the issue is of high priority, add 1 work week and if it is of medium or low priority; add 2 work weeks. Any thoughts? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula using work days
Make sure ATP is installed
=IF(Other_cell="","",IF(Other_cell="High",WORKDAY( Cell_with_date,2,Holidays),IF(Other_cell="Medium", WORKDAY(Cell_with_date,7,Holidays),WORKDAY(Cell_wi th_date,14,Holidays)))) look up workday in help -- Regards, Peo Sjoblom Portland, Oregon "trouble with work days" <trouble with work wrote in message ... I am trying to set up a formula in excel based on an issue priority ranking of emergency, high, medium and low. If an issue is of emergency priority, I want excel to add 2 workdays to the issues start date (which has already been defined in another cell). If the issue is of high priority, add 1 work week and if it is of medium or low priority; add 2 work weeks. Any thoughts? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula using work days
Hi!
I'm assuming a work week is 5 days? Date in A1, ranking in B1: =IF(A1="","",WORKDAY(A1,VLOOKUP(B1,{"Emergency",2; "High",5;"Medium",10;"Low",10},2,0))) If you want to include any holidays that should be excluded from the calculation: List the holiday dates in a range of cells somewhere, say, J1:J10: =IF(A1="","",WORKDAY(A1,VLOOKUP(B1,{"Emergency",2; "High",5;"Medium",10;"Low",10},2,0),J1:J10)) Biff "trouble with work days" <trouble with work wrote in message ... I am trying to set up a formula in excel based on an issue priority ranking of emergency, high, medium and low. If an issue is of emergency priority, I want excel to add 2 workdays to the issues start date (which has already been defined in another cell). If the issue is of high priority, add 1 work week and if it is of medium or low priority; add 2 work weeks. Any thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
Vacation Accrual Formula | Excel Worksheet Functions | |||
Sumproduct help needed! | Excel Worksheet Functions |