find date and select cell

[sselemoh2012]

vlookup does not work. i think it has to do with dates.

column a, rows 5 thru the end of data have the dates in date order ie 1/1/2013 1/2/2013 thru 12/31/2013.

cell b2 has =TODAY()

now how do i find the cell address for the date match for =today() b2 and column a row what ever todays date is. when a user opens of goes to this sheet i want the selected cell displayed on the screen.

does that make sense. i have tried vlookup and that does not work. now i think that match and index is what i am looking for, but when i do this i just get errors n/a. i have tried the following:

=MATCH("B2","A5:A370",0)

i tried vba code which i think is what i want, because i want to select the column,row of todays date from column a.

i know there is a simple answer, but it has been a few years since i have been able to work with excel formulas and vba. so i need so help in refreshing my memory.

any help is appreciated.

[Richard Buttrey]

Hi,

=MATCH(B2,A5:A370,0)

without the literal quote marks should do it. At least that will give you the row number in the range starting at A5. if you want the Excel actual row number then

=MATCH(B2,A1:A370,0)