4 Replies Latest reply on Jul 15, 2018 1:16 AM by Chris McClellan

    Rolling Dates - 12 month period

    Arihant Jain

      Hello,

       

      I want to create a 12 month rolling date like from

       

      Jan 2017 to dec 2017 will be Jan'17 rolling date

      feb 2017 to jan 2018 will feb 17 rolling date

      mar 2017 to feb 2018 will mar 17 rolling date

      and so on

      so, as and when i add new data, these date get automatically updates

       

      I have attached the worksheet, but don't know how to create such formula.

       

      Thanks for the help.

      Arihant Jain