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?