Month number calculation for to include past months

bcooke

Hello all,

Currently working on trying to get a formula to calculate the current month but -2. i.e. want it to populate if 10 to output 8. Although when January or February comes around current month of 1 or 2 will be incorrect as it will output -1 and 0. Is there a way I can have if it say January to output 11 for November and February output 12?

Current Formula being used below: 

DateTimeMonth(DateTimeToday())-2)

Again the above formula would not calculate correctly for January and February.

BrandonB

DateTimeFormat(DateTimeAdd(DateTimeFirstOfMonth(),-2,"Months"),"%m")

This will do the trick for you. The first formula shows you that you can do a datetimeadd which will subtract two months from the first of the current month. The second formula shows you the exact same formula as the one above, except it is using datetimeformat to pull out the month number. You only need the second formula for your purpose but I wanted to show both so it makes sense what is happening.