auto calculate due date in excel based on starting date

[photoxprt1868]

Hello,

I'm trying to create an excel speadsheet to track the different steps of a repeating project. Each milestone is driven by the begining date of the project. For example task 1 is due 3 days after begining the project, task 2 is due 2 weeks after, task 3 a month after and so forth on so on. Is there a way that if I define a start date I can have every other field auto populate?

Thanks in advance

 

[dhamDIT]

Hi,
If A1 is your start date
=A1+14 will give you a date 2 weeks later
Is this what you are looking for?
D

 

[SkipVought]

FYI,

Why do Dates and Times seem to be so much trouble? faq68-5827

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[photoxprt1868]

DhamDIT,

Yes, that's exactly what I'm looking for, but I'm looking for a functionality that can carry over from month to month. For example if start date is 5/27 then task two cannot be due on 5/41, but rather 6/10.

The good thing is that I don't really need it to be exact. In other words I don't need it to know that February only has 28 days, or that April has 30. It's a rough due date and as such it could be adjusted.

Thank you

 

[Lilliabeth]

If you are adding a number to a date and you're getting something like 5/41, then you don't have real dates.

See the link in Skip's post.

To be clear: 5/27/2006 + 14 = 6/10/2006

If you are getting something different, you don't have dates.

 

[photoxprt1868]

Skip,

That post gave me exactly the info I needed.

Thank you very much