Try this:

=DATE(YEAR(B3),MONTH(B3)+1,15)

HTH,
Elkar


"date function" wrote:

i'm trying to return a specific day of the month by referencing another cell.
for example, cell B3 has the date 4/28/2007. I want cell B4 to return the
15th of the month after, 5/15/2007. what is the formula to do this?