try
=DATE(YEAR(H2),MONTH(H2)+1,15)

--
Don Guillett
SalesAid Software

"date function" <date wrote in message
...
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?