Formula for named range

Giganews Newsgroups
Subject: Formula for named range
Posted by:  TUNGANA KURMA RAJU
Date: Fri, 30 Jun 2006

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.

Replies