1 2 Previous Next 17 Replies Latest reply on Jul 25, 2018 7:44 AM by Haan Haan

    Get Differences btw today and The nearest of any date earlier than today

    Haan Haan

      Hi

      Kindly refer to the attached workbook at Sheet 6.

      The expected outcome is as such:

      Today:[ Amount from Name 1(Cheras and PJ)] / [Total from HQ:A]= 0.2506

      Nearest day from Today : The nearest of any date earlier than the search date  for "Today"

                                                 Answer will be 1.3

      Differences : (Today- Nearest day from Today) / Nearest day from Today

                            (0.2506-1.3)/1.3 = -0.8072

       

      Presume the search date is 1/8/2018.

      May I know how to achieve it?

       

      Thanks

       

       

        1 2 Previous Next