Stephanie

you could use autofill. Assume your data is in column A, as in the example.
Put the formula in cell B1, or the next free column on your sheet. Move the
cursor to the bottom right corner of the cell until it turns into a
cross-hair and double click. If there are no gaps in your data, the formula
should fill down to the bottom and adjust as it goes.

So cell B1 would be: =DATE(2005,MONTH(A1),DAY(A1)+15)
B2 would be: =DATE(2005,MONTH(A2),DAY(A2)+15)

and so on

Regards

Trevor


"Stephanie Myers" wrote in
message ...
How do I apply this formula to a spreadsheet column that displays 400+
different birthdays with varying months & days?

=DATE(2005,MONTH(A1),DAY(A1)+15)

Or will I need to use a modified formula?

Thanks much!
Stephanie