Want to create a forumla on daterange

Hi Bunty

Are you particular about using formula.Why dont you try Tool->data->Filter



Thanks
Xcelion

I have a excel sheet auto generated by a process in which there are 4 columns and 150 Rows.

One column has dates data in DD-MMM-YYYY (15-May-2007) format..but the datatype of that cell is not Date.

When I click on any date let say I selected 24-Mar-2007 in formula bar instead of displaying 3/24/2007 it displays as it is 24-Mar-2007.

\1
But when i double click on this cell it shift to right alignment and display date format 3/24/2007 in formula bar.
\1

I have to create a formula using which I can see only some rows of define date range.
Means if i define range in two cells 01-Jan-2007 and 01-Jun-2007

The sheet will display only rows having this criteria. But due to this datatype problem before putting the criteria I have to double click each of the row to convert it to Date.

RightClick Format cells option is also not help full in this...


Please Help

Bunty