Thread: date function
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default date function

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?