jameswhite4684
New Member
- Joined
- Feb 20, 2015
- Messages
- 5
I have date that always increments everymonth by 1 and max number 12, as there are 12 months in a year. Sometimes this number will be max of 6. So, I am trying to figure a formula out that would, on the first of each month increase that number by 1, and on the 13th month the number will go back to 1.
If possible, I would need it to increase another cell by 1 letter. Say value A > B after 12.
A1 Contains Letter Values, B1 Contains Number Values
Example:
March - Cell A1 = N, B1 = 11 Then April comes
April - Cell A1 = N, B1 = 12 Then May comes
May - Cell A1 = O, B1 = 1
I hope this example helps. Some times I need the max number to rotate is 3 months or 6 months.
If possible, I would need it to increase another cell by 1 letter. Say value A > B after 12.
A1 Contains Letter Values, B1 Contains Number Values
Example:
March - Cell A1 = N, B1 = 11 Then April comes
April - Cell A1 = N, B1 = 12 Then May comes
May - Cell A1 = O, B1 = 1
I hope this example helps. Some times I need the max number to rotate is 3 months or 6 months.