4 Replies Latest reply on Jan 11, 2019 6:46 AM by Megha Bhatnagar

    Create a list of everyday dates

    Megha Bhatnagar

      Is it possible to create a list of dates and filter them to fall between selected start and end dates?

      Attaching a mock workbook at the end.

      For eg I have a column eff_dt i.e effective date.

      For each and every day I need to see if the max effective date is less than today.

       

      And I am looking to plot something like this:-

      Plotting max effective date for each day. I cannot figure out how to generate these everyday dates to plot the eff_dt