Extract a list from data in sheet1 to sheet2 filtered by a starting date and ending date?

Yes it is possible. Do you have a header row for your data in Sheet1, so the actual data starts in row 2 ? If not I would suggest you insert a new row 1 and put appropriate header descriptions in the cells, and if you have them there you can put this formula in G2 of Sheet1:

Formula:

Please Login or Register  to view this content.

and then copy this down to beyond your data to allow for future expansion - the hyphens will help to show you how far you have copied it.

Then put your headers in row 2 of Sheet2, and put this formula in A3 of Sheet2:

Formula:

Please Login or Register  to view this content.

and put this formula in B3:

Formula:

Please Login or Register  to view this content.

The formula in B3 can then be copied across into C3:F3, and then each cell formatted appropriately. Then you can copy the row of formulae from row 3 down into row 4 downwards as far as you think you need.

Then you can just change the dates in A1 and B1 to get another set of data displayed.

Hope this helps.

Pete

Hi Pete,

thank you for your prompt answer. I have tried the formulas you provided and none of them worked. First of all it has to do that I forgot to mention in my registration at this forum that I use Openoffice CALC. Sorry about that. So I tried to changed the formulas into CALC layout, 2 formulas failed nevertheless; only the first formula works.

After some research I came on the following formulas which work.

Sheet1.G2:

Formula:

Please Login or Register  to view this content.

Sheet2.A3:

Formula:

Please Login or Register  to view this content.

Sheet2.B3: (Same as Sheet2.A3 but selected different column)

Formula:

Please Login or Register  to view this content.

My formulas for A3 & B3 are probably longer then really necessary. Anyways, they work.

Thank you for your help Pete, much appreciated!

Aiii, I found a bug in the formula I produced. If the data in sheet1 is sorted by date, then there is no problem. However, if I have all the dates in sheet1 mixed, the formula produces not all the entries within range of the dates.

Is your formula resistant to this bug? If so, do you know the Openoffice CALC version of the formula?

Aiii, I found a bug in the formula I produced. If the data in sheet1 is sorted by date, then there is no problem. However, if I have all the dates in sheet1 mixed, the formula produces not all the entries within range of the dates.

Is your formula resistant to this bug? If so, do you know the Openoffice CALC version of the formula?