If function with date ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I create a IF formula that will state the following
If a persons membership dates falls between the following dates, then label him as Tier Tw

Prior to 7/01/03 = "Tier One
7/01/73-7/26/76 ="Tier Two
7/26/76-8/31/83+"Tier Three
after 09/01/83= "Tier Four
What would be the formula
 
Hi Jennifer
one way (with nested IFs):
=IF(A1<DATE(1973,7,1),"Tier One",IF(A1<DATE(1976,7,26),"Tier
Two",IF(A1<DATE(1983,8,31),"Tier Three","Tier 4")))

A1 stores the membership date
thought the first condition has to be prior to 7/01/73 and not 7/01/03

HTH
Frank
 
one way:

="Tier " & CHOOSE(1+SUMPRODUCT(--(A1>=DATEVALUE(
{"7/1/1973","7/26/1976","9/1/1983"}))),"One","Two","Three","Four")
 
Back
Top