If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"User" wrote in message
...
can anyone please help me out with a formula wherein i have some 100s of
records in an excel sheet,with coloums as below

S.No item No. issue date expiry date amount extension date E1 E2 E3

the said item nos. will be depening on the requirement keep on extending
the
dates in the corresponding item no in the coloums E1, E2, E3....and those
dates are recorded.

i want some technique wherein i can get the required record whose
extending
dates (E1,E2,E3..) come under a specifc date range

if i want the extending dates record whose dates fall under 01/04/10 to
30/04/10
pls suggest