Goto Cell With Today's Or Other Date

[jonoro]

In a worksheet with a long list of dates (all in one column), how to go to
the cell containing a specific date?
a) today's date (using TODAY() reference?)
b) another, specified date

 

[Eva]

YOu should be more specific on what you need. So this is what I suggest
1) use autofilter (Data/Filter/Autofilter) and pick the specific data or
pick form custom and specify which date/dates you want
2) Use advanced filter (move your list a few rows down, put the same heading
on the top of your list, leave a few rows blank and type the dates you need
to filter out) - Data/Filter/Advanced filter (list a range - your list,
criteria - your criteria on the top )
3) Create the colum with the specific formula for dates, and then filter it
out (for example =today() - but this formula changes every day

Click yes if I helped

 

[jonoro]

Hi, Eva, thanx for your reply.

What I'm trying to do is:

locate and goto a specific cell;

let's say I'm working in a part of my worksheet where the date cell in that
row is 11/20/07: without having to do a massive scroll or "Page Up" or "Page
Down", I want to jump directly to the cell containing today's date (whenever
today is), or 12/31/09, say, without knowing the exact cell address of that
date;

e.g., find and goto the cell where the value is TODAY()

Note: any particular date appears only once in the worksheet