Hello,

I have data coming out of a system where the month number and year are coming out in two separate columns. Example: One cell has a 3 and the other a 16. For calculation purposes there is another field that shows the number 4. 4 represents the number of months to count back from 3 in order to grab a CPI index to calculate CPI increases. The issue I am having is if I subtract 4 from 3 I get negative 1. I need to take 4 away from three to get 11 (November). So that the calculation will grab the CPI index that was reported 4 months before the 3(March). any suggestions? If it were farther along in the year it would work fine. It is when it crosses years that it becomes an issue and the fields are not coming over in a date format where the subtraction would work.

Thanks in Advance!