Data retrieve based on date

Dear Excel Expert,

Please kindly help to develop a formula to extract some data. Based on date in B column, I would like to extract some data:

Requirement 1 formula: First I need a formula to extract some data based on date in B column and matched with top row date information. For example, 15012004
based on this date, I want to extract -30 days before this date (15012004=which is 0 day for each row) and +30 days.

Requirement 2 formula: Second formula require to extract data only in negative side (-) side from (15012004=which is 0 day for each row). But that data will require from -60 days onwards to -240 days (-60 days t0 -180 days).

Formula should be end of each row to drag right or left to extract the data.

Thank you for your time.

Regards
Shams