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

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?

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?

One way:

assuming the due date in A1:

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


In article ,
K Svoboda <K 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?

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?

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?