Adding Dates

[gymwrecker]

I'm working on an excel spreadsheet that contains dates. If I have a cell with a specific date, how could, by adding 6 months, have the next cell display the new date? What formula, procedure should I use to add dates?, in this case, add six months to the date on one cell?

 

[gymwrecker]

Yogi, your formula worked perfectly; no problems at all.

Thanks!!

 

[chouston]

what if I wanted to use this function in VBA? i.e.

ElseIf OutDate > (begDate + '6 months')Then..