software

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?

Make sure ATP is installed

=IF(Other_cell=quot;quot;,quot;quot;,IF(Other_cell=quot;Highquot;,WORKDAY( Cell_with_date,2,Holidays),IF(Other_cell=quot;Mediumquot;, WORKDAY(Cell_with_date,7,Holidays),WORKDAY(Cell_wi th_date,14,Holidays))))

look up workday in help--
Regards,

Peo Sjoblom

Portland, Oregon

quot;trouble with work daysquot; lt;trouble with work gt;
wrote in message ...
gt;I am trying to set up a formula in excel based on an issue priority ranking
gt; of emergency, high, medium and low. If an issue is of emergency priority,
gt; I
gt; want excel to add 2 workdays to the issues start date (which has already
gt; been
gt; defined in another cell). If the issue is of high priority, add 1 work
gt; week
gt; and if it is of medium or low priority; add 2 work weeks. Any thoughts?Hi!

I'm assuming a work week is 5 days?

Date in A1, ranking in B1:

=IF(A1=quot;quot;,quot;quot;,WORKDAY(A1,VLOOKUP(B1,{quot;Emergencyquot;,2; quot;Highquot;,5;quot;Mediumquot;,10;quot;Lowquot;,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=quot;quot;,quot;quot;,WORKDAY(A1,VLOOKUP(B1,{quot;Emergencyquot;,2; quot;Highquot;,5;quot;Mediumquot;,10;quot;Lowquot;,10},2,0),J1:J10))

Biff

quot;trouble with work daysquot; lt;trouble with work gt;
wrote in message ...
gt;I am trying to set up a formula in excel based on an issue priority ranking
gt; of emergency, high, medium and low. If an issue is of emergency priority,
gt; I
gt; want excel to add 2 workdays to the issues start date (which has already
gt; been
gt; defined in another cell). If the issue is of high priority, add 1 work
gt; week
gt; and if it is of medium or low priority; add 2 work weeks. Any thoughts?