how to calculate a projected date

  • Thread starter Thread starter farmgirl
  • Start date Start date
F

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?
 
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?
Click to expand...

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
 
Back
Top