Assuming your TCM date is in B2, put this in C2:

=DATE(YEAR(B2),MONTH(B2)+6,DAY(B2))

Use a similar formula for your other dates, but just ensure that the
formula points to the appropriate cell.

Hope this helps.

Pete

On Aug 5, 12:34*am, lonedove288
wrote:
I haven't used Excel in a while but I need to figure a formula to change
dates by six month increments in several different columns. I can't, for the
life of me, remember how to make the formula for that. The spreadsheet is
like follows:

Name * TCM date *Next TCM Assess Date Next Assess Date and so on

I need the formula to update the Next TCM, Next Assess Date and so. I know
it's probably something simple and I'm just brain dead but any help would be
great.

Thanks