If you're date is from 4/1/2007 to 4/15/2007 and you want to return
"4/15/2007"...or if it's 4/16/2007 to 5/15/2007 and you want to return
"5/15/2007", then:
=IF(DAY(A1)15,DATE(YEAR(A1),MONTH(A1)+1,15),DATE( YEAR(A1),MONTH(A1),15))
HTH,
Paul
"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?