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

    Formula for Previous Month Number



      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.