3 Replies Latest reply: Nov 10, 2013 10:43 AM by Srikanth P RSS

    Date Format issue while Creating Rolling Months

      Hi All,

       

      I am trying to create a rolling monthly chart for last 12 months with my date format available in 'MMYY'(0113) or 'MMYYYY'(012013) format. I am trying to apply date format formula to it and also addmonths formula for calculations. However its showing entirely different values of dates when i am doing so.

      For eg: 1213 is converted to Apr-1903

                  122013 is converted to Jan-2234

       

      I have attached my working file to demonstrate this. Please guide me how i can use this to create a rolling months chart and the changes in date format too. Thanks in Advance.