Okay, you don't need to specify the end date, as it will be 30 days from your start date and we can get Excel to add on those 30 days.
I've renamed your original sheet Main, and set up a new sheet Recent. In both of them I've inserted a new column A with this formula in A2 of Main:
this compares the date with the start and end dates and sets up a simple sequence for records whose date is within the range.
In the Recent sheet you can set your starting date in cell C1 (coloured yellow). This formula in A4:
finds where the records with an appropriate date in the Main sheet are located, and this formula in B4:
brings the corresponding data across from column B. This formula can be copied across to E4, though you will need to change to a date format for cell C4. These formulae can then be copied down as far as you think you may need - the hypens indicate how far you have copied.
Hope this helps.
Pete
Bookmarks