Formula for Previous Month Number

Mon, 02 May 2016 15:22:20 GMT

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,

Re: Formula for Previous Month Number

sunny_talwar — Mon, 02 May 2016 15:46:39 GMT

May be something like this:

Month(AddMonths(MakeDate(Year(Today(), Date#(Month, 'MMM')), -n))

Replace n with the number of months you wish to go back and Month with whichever month you plan to start with