9 Replies Latest reply on Jul 19, 2018 3:36 AM by Mahfooj Khan

    Calculating differences between the selected date and the max 1 day before

    Haan Haan

      Hi all

       

      May I know how to do it if I want to calculate the the differences between the selected date and the max 1 day before?

      The reason i asked for max 1 day before is that let say above 1 day of selected date might be public holiday which is no data...

      For eg in my workbook, the  selected date is 1/4/18, 1/3/18 got no data so the differences should be (1/4/18- 1/2/18) / 1/2/18

       

      May I know how to achieve this?