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

"John Mansfield" wrote:

Try something like:

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

----
Regards,
John Mansfield
http://www.pdbook.com

"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?