Formula using work days

  • Thread starter trouble with work days
  • Start date
T

trouble with 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?
 
P

Peo Sjoblom

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_with_date,14,Holidays))))

look up workday in help


--
Regards,

Peo Sjoblom

Portland, Oregon
 
B

Biff

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
 
Top