IF statement determining day is greater then or less then a date

[olivia.ruiz82]

Help determining if a date or number of days is greater then or less then a date.

Computer System: Excel 2007, Windows XP
In Cell A2, list of dates i.e. 12/30/2010

I would like to create a formula (IF statement maybe?) to see if the date in A2 is less then 14 days, then return "3", if false then check to see if the date in A2 is greater than "15" days, but less than "28" days, then return "4", if false, then check to see if A2 is equal to "29", "30", "31", if true then return "5".

I have come up with "=IF(U3<="14","3",IF(U3>="15"<="28","4",IF(U3=29,"5",IF(U3=30,"5",IF(U3=31,"5")))))" but this returns "3" when A2 is 12/30/2010.

I also tried using the DAY function to covert the date to number of days, which looks like "=IF(DAY(U2)<="14","3",IF(DAY(U2)>="15"<="28","4",IF(DAY(U2)="29","5",IF(DAY(U2)="30","5",IF(DAY(U2)="31","5")))))"

 

[VoG]

Try like this

=LOOKUP(A2-TODAY(),{0,15,28},{3,4,5})

 

[olivia.ruiz82]

Thank you so much. I never thought about the lookup function. I really appreciate your help. I guess I was thinking too hard....

I modified the formula to =LOOKUP(DAY(U5),{0,15,28},{3,4,5})
I was getting an error "#N/A" for previous dates I was trying to evaluate for, so I changed it and got the result I needed.