date formula issues?!?!

M

Mike

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.
 
M

Mike

Nevermind, I got it!

In C15 "="WE "&TEXT((RIGHT(DB3,8)+7),"mm/dd/yy")"
and in D15 "="WE "&TEXT((RIGHT(C15,8)+7),"mm/dd/yy")"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top