I have a date column which populates based on fortnightly basis ( Fortnightly is 14 days but I receive the data earlier ). My calculation should be based on Max(date) and the previous day that is available.
Date received 15/04/2022 30/04/2022 12/05/2022
From the above dates, how do i select 30/04/2022 and 12/05/2022 only? and for the next month also the logic should work the same way like selecting 12/05/2022 and 30/05/2022 (Future date, which is currently not available) automatically.
This might be an easy one but appreciate your help.