Date Formula


S

Stephanie

I have a date in cell D8 which is a week ending date (on
Sunday). In cells C12, E12, G12, I12, K12, M12, and O12
are dates for days Saturday through Friday. What formula
would I use to calculate the dates for each day of the
week based on the weekending date in cell D8?

Hope I haven't confused you.

Steph
 
Ad

Advertisements

B

Bob Phillips

Stephanie,

Not sure about Saturday, one of following
C12: =D8-1 or =D8-8
E12: =D8
G12: =D8-6
I12: =D8-5
etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Ad

Advertisements

S

Stephanie

Thanks. I did that but left out the =. Always something
small I miss.

Thanks again.
Steph
 

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