Date Lookup Logic

[rammuthiah]

I have 10 months data in 2 sheets. If I select one date from 1 sheet, that should show the previous 30 days data in another sheet.

I tried with below script. But it is showing all the previous dates.

=if(date( Sheet2 Date )<date(Sheet 1 Date ),date( Sheet2 Date),null())

And tried by adding +30,

=if(date( Sheet2 Date )<date(Sheet 1 Date )+30,date( Sheet2 Date),null())

It doesn't work. Can anyone help in this regard?

[techvarun]

Share a sample app to get faster responses and to understand the problem better.

[rammuthiah]

Need script for below Logic