Thread: Month Additions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Robert is offline
external usenet poster
 
Posts: 193
Default Month Additions

Hi
I was wondering if there is a way to limit additions to 12 numbers only.
For example, I have a column of months (in numbers) in A and in B, I have
month+2.
Col A Col B
1 3
2 4
3 5
4 6
5 7
6 8
7 9
8 10
9 11
10 12
11 13
12 14
But instead of 13 and 14 in ColB I need it to go back to 1 and 2 respectively.

Any help would be greatly appreciated.
Thanks