Trying to get cells to return a range based on two dates

welcome to the forum, redjayhawk11. say you have these in E1:E6
0
1
4
7
10
14

and these in F1:F6
B: On Time
C: 1-3 Days
D: 4-6 Days
E: 7-9 Days
F: 10-13 Days
G: 14+ Days

so try:
=IF(A2="","",IF(B2<A2,"A: Early",LOOKUP(B2-A2,$E$1:$F$6)))

if you don't wish to have that table, then:
=IF(A2="","",IF(B2<A2,"A: Early",LOOKUP(B2-A2,{0,"B: On Time";1,"C: 1-3 Days";4,"D: 4-6 Days";7,"E: 7-9 Days";10,"F: 10-13 Days";14,"G: 14+ Days"})))

you're very welcome.

=IF(A2="","",IF(B2<A2,"A: Early",
this is the easier part. if A2 is blank, show a blank. if B2 is lesser than A2, show it as "A: Early".

LOOKUP(B2-A2,$E$1:$F$6)))
LOOKUP works mostly with a sorted list of ascending order. that's why i had my values in E1:E6 from 0-14. B2-A2 would give me the difference. the LOOKUP formula then looks for a value that is greater than or equals to it from the bottom up. so if the difference is 8. it looks at 14. not greater than or equal to it. so it compares with 10. fails again. compares with 7. this time, it is greater than it despite not being equal to it. it will then return the value of the next column i did; E: 7-9 Days

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.