Hi!

I have no idea how you intend to use this so I can't guarantee this for
robustness:

=OFFSET(Sheet1!$B$2,MATCH(Sheet1!$A$2,Sheet1!$B$2: $B$9)-1,,MATCH(Sheet1!$A$3,Sheet1!$B$2:$B$9)-MATCH(Sheet1!$A$2,Sheet1!$B$2:$B$9)+1)

Use the appropriate sheet name.

Biff

"TUNGANA KURMA RAJU" wrote in
message ...
My data is:
cell a2=24/jun/2006
cell a3=01/jul/2006

column B(b2:b9)
-------------------
21/jun/2006
22/jun/2006
23/jun/2006
26/jun/2006
27/jun/2006
28/jun/2006
29/jun/2006
30/jun/2006
I would like name a range in col.B by looking date values from col
A(a2:a3).As per my above data I want to name a range $b$4:$b$9.I am
looking
formula to define the range name,what should I write in 'refers to' box.