Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Month Additions
Try this formula
=IF(A1+2 = 12, 12, MOD(A1+2, 12)) It assumes your data is in A1 - A12 HTH "Robert" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Month Additions
Sorry. That formula dies at 24, 36... This formula works for any values
=IF(MOD(A1+2, 12) = 0, 12, MOD(A1+2, 12)) HTH "Jim Thomlinson" wrote: Try this formula =IF(A1+2 = 12, 12, MOD(A1+2, 12)) It assumes your data is in A1 - A12 HTH "Robert" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Useful Additions | Excel Discussion (Misc queries) | |||
Additions | Excel Discussion (Misc queries) | |||
Filter out unique additions month to month | Excel Discussion (Misc queries) | |||
Can I allow Additions but not Edits? | Excel Discussion (Misc queries) | |||
Cell Additions | Excel Worksheet Functions |