Thread: Month Additions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Month Additions

One way

If A are dates

=MONTH(DATE(2005,MONTH(A3)+2,1))

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Robert" wrote in message ...
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