1 Reply Latest reply: May 2, 2016 11:46 AM by Sunny Talwar RSS

    Formula for Previous Month Number

    Ronak Patel

      Hi,

       

      I am trying to come up with a formula/function that returns a month number that is n months prior to a given month.

       

      My function should have two arguments: monthnum and n

      For example:

      f(2,2)=12     -> the month two months before Feb. is Dec.

      f(4,3)=1       -> the month three months before Apr.. is Jan.

       

      Best,

      R