OK
After consulting with the boss.....err wife we have decided it to be a bit too risky to share the spreadsheet. Basically, it all came down to why take the risk when Im the only one that knows how to use it? I have it very fine tuned to my liking and it requires a bit of maintenance to keep going.
However, I will share the formula that made it all possible for me and explain how I have used it the best I can.
The spreadsheet has several tabs, one of them being a main or "HOME" tab as I call it. This tab never has any information input into it, but simply displays information you need to know such as what plants are in what stages and how long they have been alive, vegging and/or flowering.
Other tabs are as follows: Current Plants, Harvest, Feeding, DATA.
DATA is where I keep all my notes, some calculators and a few other random things. Feeding is where I simply input the date I last fed each plant. Harvest is where I copy & paste all my harvested plants to to keep a log containing: name, age, days vegged, days flowered, height & weight. It has by far been the most useful tab for following my progress and making improvements.
My "Current Plants" tab is where most of the info is input. I have a table for each grow section (Moms, Clones, Seedlings, Veg, Flower) and as I plant or transplant, I input data as needed (name, date planted/cloned, date of veg start, etc.)
No here is where the formula comes in. The formula itself it this: =IF(A1<>"",TODAY()-(A1)&" days","")
What this will do, is display the amount of days between the date in A1 and today. If there is nothing in A1, it displays nothing. Now that single formula is all I started with, and I had to tweak it for a few entried but for the most part it stayed the same. Now obviously A1 will be replaced with the cell you enter the date into, but this is really all you need to get started. Let me give you an example of exactly how i use a version of the formula:
On the "Current Plants" page in cell D4 is where the first day of flower is entered for the first plant in my list. On my HOME page right under "Days Flowering" for my first plant in my list is this formula: =IF('Current Plants'!D4<>"",TODAY()-('Current Plants'!D4)&" days","") This cell (today that is) displays the following: 50 Days
Now if i dont have a plant in that section on the "Current Plants" page, it will display nothing instead of "VALUE###"
I know it was a long and drawn out explanation, maybe Ill write a thread once I get it more fine tuned and explain it thoroughly, but I hope this has helped at least someone
KB