View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default date formula issues?!?!

I have a series of dates going from C3 to DB3 in the form "WE mm/dd/yy". Say
my last date is WE 08/08/09. I want to have cell DC3 to equal "08/15/09" as
well as the next twelve cells to be subsequent weeks. I would like a formula
that updates automatically as I refresh my data (so next week when DB3 equals
"WE 08/15/09" DC3 will automattically update itself to eqaul "WE 08/22/09").
Is there a formula that could do this. Something like telling Excel to look
at my entry as a date and add 7 days to it or something?

Thanks for your help.