Formula to make a Seed Starting Chart

S

something_clever

Someone helped me with this a few years ago and I have since lost his
instructions. Can someone help me to know what formula I use in
making a chart for starting my seeds. I would like to be able to have
one cell have the last frost date in it and then be able to type in a
number in another cell which represents the number of weeks the seeds
need to be started before or after the last frost date, and then the
date I should start the seeds would appear in another cell. Did I
make any sense? Thank you!
 
J

Joel

the fomula is
=B1-(7*B2)

1) Type in cell A1 Frost Date - the actual letters FROST DATE
2) Type in cell A2 Weeks - the actual letters Weeks
3) type in cell A3 Plant Date - the actual letters PLANT DATE
4) type in cell B3 the formula = B1-(7*B2)
5) format cell B3 with date
Highlight cell B3
In the format menu select number - date

entering numbers
in Cell B1 type date such as 2/15/07
in cell B2 type in the weeks
cell B3 will show the plant date
 

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