Lookup formula?
 

Hey all, I have a list of dates that occur every other saturday for the next
year in excel:

7/26/08
8/9/08
8/23/08
etc...

I need to look at a cell that is entered, for example: 8/16, and I need the
result in another cell to give me 8/9. So if the date entered (8/16) falls
between two dates, the result needs to be the earlier one. Any ideas? I
tried if, then statements, but I have 26 dates, so I can nest enough. Any
help would be great! Thanks!

Lookup formula?
 

Kelly wrote:
Hey all, I have a list of dates that occur every other saturday for the next
year in excel:

7/26/08
8/9/08
8/23/08
etc...

I need to look at a cell that is entered, for example: 8/16, and I need the
result in another cell to give me 8/9. So if the date entered (8/16) falls
between two dates, the result needs to be the earlier one. Any ideas? I
tried if, then statements, but I have 26 dates, so I can nest enough. Any
help would be great! Thanks!



With your dates in A1:A26 and your "date entered" in B1, put the following in C1:

=VLOOKUP(B1,A1:A26,1, TRUE)

Lookup formula?
 

THANK YOU SO MUCH! That is exactly what I needed. You are wonderful!

"Glenn" wrote:

Kelly wrote:
Hey all, I have a list of dates that occur every other saturday for the next
year in excel:

7/26/08
8/9/08
8/23/08
etc...

I need to look at a cell that is entered, for example: 8/16, and I need the
result in another cell to give me 8/9. So if the date entered (8/16) falls
between two dates, the result needs to be the earlier one. Any ideas? I
tried if, then statements, but I have 26 dates, so I can nest enough. Any
help would be great! Thanks!



With your dates in A1:A26 and your "date entered" in B1, put the following in C1:

=VLOOKUP(B1,A1:A26,1, TRUE)