Formulas for dates

R

ry.squared

Hello,
I'm using Excel to create a workflow chart for myself. I have six
columns signifying various events in the progress of a project. I'd
like to be able to just enter the start date in the first column, and
have Excel fill in the other 5 columns for me.
The start date is always a monday (we'll call that June 4, 2007). The
next column should be June 8, 2007, so 4 days later. Is there a
formula that I can create that will add X amount of days to the start
date?
Thanks for your help!
Ryan
 
C

CyberTaz

I must be missing something in your question. The way I understand your
need, you can (assuming the "start date" is in cell A1) enter a formula
incell B1 that reads:

=A1+4

Then use the Fill Handle to copy to cells C1, D1 & E1. Other options are
probably available as well, but that's the quickest & easiest I know of.
 

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