Perhaps this is what you want.....assuming your starting date is in A1

=(MONTH(A1)+6)&"/"&1&"/"&YEAR(A1)

Vaya con Dios,
Chuck, CABGx3



"Jason" wrote:

I have a spreadsheet where I need Excel to calculate (ADD) 6 mouths
automatable for anther date. The mouths need to be consecutive. IE in one
cell I will put 1/29/2005 and in anther cell I need Excel to put 6/1/2005