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

-- 
Thanx.

    JR

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
-- 
Greatly appreciated
Eva


"jonoro" wrote:

> 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
> 
> -- 
> Thanx.
> 
>     JR

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

-- 
Thanx.

    JR


"Eva" wrote:

> 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
> -- 
> Greatly appreciated
> Eva
> 
> 
> "jonoro" wrote:
> 
> > 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
> > 
> > -- 
> > Thanx.
> > 
> >     JR