market-farming AT lists.ibiblio.org
Subject: Market Farming
List archive
[Market-farming] Nifty Excel formula for calculating days from sprout to harvest
- From: Richard Robinson <rrobinson AT nasw.org>
- To: Market Farming <market-farming AT lists.ibiblio.org>
- Subject: [Market-farming] Nifty Excel formula for calculating days from sprout to harvest
- Date: Wed, 5 Jan 2011 09:28:32 -0500
With a little time on my hands, and not yet having fancy software to do it for
me, I have been looking at my planting and harvest dates on an Excel sheet to
compare catalog days to harvest to actual. Excel will calculate the number of
days between two dates with a simple function. For those who are interested,
it
goes like this:
--let's say your planting date was March 29, and your first harvest date was
June 7.
--On your spreadsheet, let's say the March 29 date is in cell B5, and June 7
is
in B6.
--to calculate the number of days between them, choose another cell and type
in
this formula: =datedif(B5,B6,"d")
--the number of days between them, 70, appears in the cell.
It's even simpler to add days to a given date, to get an expected harvest
date,
for instance.
--If you wanted to know what 70 days after March 29 was, and March 29 was
again
in B5, you would just choose another cell and type in this formula: =B5+70
--the date "June 7" appears in the cell.
Richard Robinson
www.nasw.org/users/rrobinson/
Hopestill Farm
www.hopestill.com
- [Market-farming] Nifty Excel formula for calculating days from sprout to harvest, Richard Robinson, 01/05/2011
Archive powered by MHonArc 2.6.24.