Formula for Previous Month Number

[#1]

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

[sunny_talwar]

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