View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lonedove288 lonedove288 is offline
external usenet poster
 
Posts: 1
Default formula to add six months to date

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