=date(year(a1),month(a1)+6,day(a1))



Excel User wrote:

Greetings! I have a column with dates. I need to add 6 months to those dates
and place the new dates in a new column. How do I do that? Many thanks.

--

Dave Peterson