how to calculate a projected date

[farmgirl]

I'm working on planting schedules using Excel 2003. I have a column
containing weeks to maturity and a column containing the planting
date. How to a calculate date the plants will be available. For
example I planted the seed on 1/12/10 and it takes 6 weeks to mature
so the date I want is 6 weeks from 1/12/10?

 

[Ron Rosenfeld]

I'm working on planting schedules using Excel 2003. I have a column
containing weeks to maturity and a column containing the planting
date. How to a calculate date the plants will be available. For
example I planted the seed on 1/12/10 and it takes 6 weeks to mature
so the date I want is 6 weeks from 1/12/10?

With planting date in A1, and weeks to maturity in B1, something like:

=a1+b1*7

--ron

 

[Gord Dibben]

Date planted 1/12/2010 in A1

Number of Weeks to maturity in B1

In C1 =A1+(B1*7) returns date at maturity...........2/23/2010


Gord Dibben MS Excel MVP

 

[Ashish Mathur]

Hi,

Try B2+(C2*7). B2 has the planting date and C2 has the weeks

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com