I have the following formula that gives me the date at the end of the month
six month on. eg if I put a date of 15 Aug 06 in cell A1, the result in A2
would be 28 Feb 07. What I need also if the date in A1 is a month early (say
28 Jul 06), the result in A2 still needs to be 28 Feb 07. I hope I made it
clear as mud!!

=EOMONTH(A1,6)
--
ASU