If the date in B3 can be before the 15th the try:

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"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?