Depending on what you are doing, the formulas presented may not give you the answer that you require. For example, if you work for a dentist or a doctor and you are scheduling the next appointment for 6 months hence, the previous formulas may give you a Saturday date (with my regional settings, 30 April 04 was a Friday. The formulas give 30 October 04, but that’s a Saturday).
You may be better off with adding 26 weeks instead of adding 6 months. The next appointment will be on the same day of the week as the previous appointment.
=A1+(7*26).
Regards,
Mike