6 Replies Latest reply on Oct 2, 2018 1:45 AM by Haan Haan

    Return Value for Min & Max Date in a selected period

    Haan Haan

      Kindly refer to the attached workbook.

      What are the formula that will return when i select

      YTD-  (26 Sept 2018- 1 Jan 2018) which is   1487- 1482 = 5

      QTD- (26 Sept 2018- 1 July 2018)   1487-640=847

      MTD- (26 Sept 2018- 1 Sept 2018)  1487-1262=225

       

      It is actually the formula that will return max date of sales minus min date of sales based on the period selected.

      Thanks