Moving to today's date and/or opening doc at today's date

**joeljoel** · 08-07-2011, 05:25 PM

I have a spreadsheet with the dates going down the rows in column A, with a data in other columns. Rows go over 1000. I am wondering about two things.

First - is there a way to open my doc so that the row of today's date is on the screen somewhere?

Second - is there a way while in the spreadsheet to quickly go to the row of today's date?

I prefer not use VBA if possible, since I have never doe this. Am I asking too much?

Thank you!!

**martindwilson** · 08-07-2011, 06:10 PM

just us index/match or vlookup with today() to display todats row at top. easiest way to get to todays actual row would be using find,ie copy todays date ctrl+c ctrl+f to open find .ctrl+v to paste find next
this example displays todays data in row 1

**joeljoel** · 08-07-2011, 06:33 PM

Thanks Martin. This might work - but it wasn't what I was thinking about. I was hoping to keep the rows as they are and just have excel open at the row of today's date. OR quickly skip to today's date from anywhere in the document.

**martindwilson** · 08-07-2011, 07:07 PM

ok try a hyperlink using hyperlink() function and address() /match()/today() see cell n1
i used freeze panes to keep row one visible

**joeljoel** · 08-07-2011, 08:05 PM

Martin - very clever. I like this a lot. I need a minor tweak, though.

I am using a list of dates that only includes weekdays, however. So when I first copied the formula it gave me an N/A error since the result didn't exist. I added in this weekend's dates and then it brings me to Friday Aug 5th. (It actually brought me to Thursday Aug 4th when I only added in today - and then to Fri 8/5 when added in Sat). Not sure why. Any ideas on how to tweak the formula to bring me to the nearest weekday to today?

I've attached mt test worksheet so you can see exactly what I have.

**martindwilson** · 08-08-2011, 05:55 AM

=HYPERLINK("#"&ADDRESS(MATCH(TODAY(),A4:A5002,1)+3,1,1),"go to today")
the offset for the match needs to be 3 as you are starting in row 4 to obtain the correct row for cell address, also set the MATCH(TODAY(),A4:A5002,1) criteria to 1 in the match this will find the he largest value that is less than or equal to lookup value
so if today is a saturday/sunday it will go to friday before