S
spalmarez
I have a dilema. I am trying to grab a date. Here are my columns, but
have more than this:
START END START_1 END_1 START_2 END_2
23-Dec-04 17-Jan-05 25-Jan-05 15-Feb-05 23-Feb-05 16-Mar-05
Basically, I enter a date I want to look up and get the value, whic
works for a few columns but not for 26 columns.
Here is my formula:
A4= 01/26/05 or any date
=IF(AND(A4>=F4,A4<G4),"A",IF(AND(A4>=H4,A4<I4),"B",IF(AND(A4>=J4,A4<K4),"C",IF(AND(A4>=L4,A4<M4),"D",IF(AND(A4>=N4,A4<O4),"E",IF(AND(A4>=P4,A4<Q4),"F",IF(AND(A4>=R4,A4<S4),"G")))))))
But I get an error when I enter more in. Could anyone provide feedbac
on this.
Basically I am looking for The Start date and End date between m
value. Any help would be appreciated or idea
have more than this:
START END START_1 END_1 START_2 END_2
23-Dec-04 17-Jan-05 25-Jan-05 15-Feb-05 23-Feb-05 16-Mar-05
Basically, I enter a date I want to look up and get the value, whic
works for a few columns but not for 26 columns.
Here is my formula:
A4= 01/26/05 or any date
=IF(AND(A4>=F4,A4<G4),"A",IF(AND(A4>=H4,A4<I4),"B",IF(AND(A4>=J4,A4<K4),"C",IF(AND(A4>=L4,A4<M4),"D",IF(AND(A4>=N4,A4<O4),"E",IF(AND(A4>=P4,A4<Q4),"F",IF(AND(A4>=R4,A4<S4),"G")))))))
But I get an error when I enter more in. Could anyone provide feedbac
on this.
Basically I am looking for The Start date and End date between m
value. Any help would be appreciated or idea