Forum Discussion
Calculated planting week
Thank you so much for your reply.
I have a lot to learn still about Excel and every little bit of information brings me closer to the answers I am looking for.
Would love to pass this to someone willing to take it on as commisioned work but have tried this in the past and have had very dissapointing results as I didn't understand Excel well enough to explain what I wanted and the excel experts didn't understand the desired outcome well enough.
Therefor trying to further educate myself.
Your suggestions are great but I need a solution that allows for changing crop growing times throughout the year with multiple planting dates for the same crop so we have continues flowering over a much larger period of time.
You can combine data from two sheets in Excel by using the Consolidate feature.
You can also create a dynamic list in Excel based on criteria by using the FILTER and OFFSET functions.
To create a list of when plants should be planted, you can use Excel formulas to calculate the planting dates based on your last frost date and the growing time of each plant. You can also use a template that has already been created from Mr. Patrick2788 for seed starting and planting schedules.
To create a dynamic list of when plants should be planted, you can use INDEX - MATCH with other functions. This will allow you to create a list that changes as you add new data to your spreadsheet.
Furthermore, if I may recommend, insert a file (without sensitive data) and explain your project step by step on the basis of this file. At the same time, it would be an advantage if the digital environment was known, such as Excel version, operating system, storage medium, etc..
Thank you for your patience and understanding