Try this:

Enter 50,000 in B1

Enter this formula in B2 and copy down as needed:

=B1+OR(MONTH(A2)={1,7})*500

Assumes there are no empty cells within your date range.

--
Biff
Microsoft Excel MVP


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