Dates

[justlearnin]

I have three cells on my worksheet that use dates. The dates that I use are
the last day of the month. I want the first one to be inputed. The third one
I want to be the same as the first, but the second to be the 15th of the
month.

date1 7/31/2006
date2 7/15/2006
date3 7/31/2006

How can I do this since some months have 30 and some have 31?

[Flintstone]

Justlearnin:

Assuming cell A1 is your input date, place this formula in cell A2.

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

Place this formula in cell A3.

=DATE(YEAR(A1),MONTH(A1)+1,1)-1


Matt