2 Replies Latest reply: Oct 9, 2017 1:28 AM by RAM MUTHIAH M RSS

    Date Lookup Logic

    RAM MUTHIAH M

      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?