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?