| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lookup a date between other dates
I have a dilema. I am trying to grab a date. Here are my columns, but I 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, which 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 feedback on this. Basically I am looking for The Start date and End date between my value. Any help would be appreciated or idea. -- spalmarez ------------------------------------------------------------------------ spalmarez's Profile: http://www.excelforum.com/member.php...o&userid=15961 View this thread: http://www.excelforum.com/showthread...hreadid=274366 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Lookup the latest date in a range so it appears as my result | Excel Discussion (Misc queries) | |||
| How can I hide points for future dates on a Year to Date chart? | Charts and Charting in Excel | |||
Threaded Mode
