How do I set If Statement to set Priorities, off of dates due?

K

K Svoboda

I am trying to set up If Statements to read dates for several projects and
from those dates set priority levels of A, B, C, etc... Can anyone offer
assistance?
 
J

John Mansfield

Try something like:

=IF(B1=DATE(2005,1,1),"A",IF(B1=DATE(2005,1,2),"B","C"))
 
J

JE McGimpsey

One way:

assuming the due date in A1:

=IF((A1-TODAY())<=0,"HOT",IF((A1-TODAY())=1,"Short-Term","Long-Term"))
 
P

Peo Sjoblom

If you have more than 3 levels you might want to consider a vlookup table

=VLOOKUP(B1,F3:G8,2)

where for instance F3:F8 would hold the dates and G3:G8 the priority levels
where the table might look like

1/1/2005 A
1/2/2005 B
1/3/2005 C
1/4/2005 D
1/5/2005 E

Regards,

Peo Sjoblom
 
K

Karen Svoboda

Is there an easy way if you are looking at 30 different projects over the year?
 
Top