Return date as 15th of month

[jeffbristow]

I have a date in A1: 4/11/2011.

I want a formula in B1 to make it the 15th of the month. This will be a recurring issue with thousands of rows. I want to make them all the 15th of the month listed in the current "date column" which is column A.

Can someone please assist?

 

[VoG]

Try

=DATE(YEAR(A1),MONTH(A1),15)

 

[SteveO59L]

=("15"&"-"&(MONTH(A1))&"-"&YEAR(A1))*1

formatting b1 as date

 

[jasonb75]

or

=EOMONTH(A1,-1)+15

=SUBSTITUTE(TEXT(A1,"m/d/yyyy"),DAY(A1),15)

 

[jasonb75]

Simplifying the last one (based on a suggestion in another thread)

=TEXT(A1,"mm-yyyy")+14

 

[barry houdini]

..or possibly

=A1-DAY(A1)+15