One way:

B1: =50000+500*INT((ROW()-1)/6)

or, equivalently:

B1: =500*INT((ROW()+599)/6)


COpy down

In article ,
Ashman wrote:

I have a list of the months over the next 3 years in column A (format is
01-Jan-08). Next to that list there is another list of values (starting at
$50,000) next to each date. In January and July each year (except for Jan
08), I want $500 added to the $50,000, so by the end of the 2nd year, the
value is $52,000. Do I use DATEVALUE in an IF or something else? Below is
an example of what I mean. Please help!

A B
1 1-Jan-08 50000
2 1-Feb-08 50000
.
.
6 1-Jun-08 50000
7 1-Jul-08 50500
.
.
12 1-Dec-08 50500
13 1-Jan-08 51000