Using the EDATE function

Initial date

4/1/2014

Date exactly 6 months forward

<== Use the EDATE function to determine the exact date and format as a date exactly like cell B3 (xx/xx/xxxx)