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?

On Mon, 11 Jan 2010 15:52:06 -0800 (PST), farmgirl
wrote:

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

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


On Mon, 11 Jan 2010 15:52:06 -0800 (PST), farmgirl
wrote:

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?

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"farmgirl" wrote in message
...
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?