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 Svoboda" wrote:

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?