0 Replies Latest reply on May 21, 2016 3:21 PM by Joe Choueiri-Oracle

    show prior calendar month up to 5th working day of the current month

    Joe Choueiri-Oracle

      Hi

      If you can help please.

       

      I want to have a formula that allows me to do the following- image attached.

      Any day I run the report within the period of time between May 09 and June 08 then I get data for May 01 until June 06 ( 5th working day of the month) and so on...so if I run the report on June 07 then I get From June first until July 8 (5th day of the month).

       

      Thanks

      Joe Timeline for SCA.png