|
South Georgia | That will work for a single instance, but if the next date you entere is from a different year, then you'll get a different number.
Maybe there's a different way to achieve what I'm after. My goal is to build a spreadsheet where I can graph cotton yield, by planting date, for multiple years. So I've got yield data for multiple fields, for multiple years, and I want to graph the yield based on planting date. Make sense? So most of the dates are going to be in May, but over about 6 years.
Any graceful ideas? I guess I can convert them all manually and enter the day-number, but that's really tedious. I did find a function, can't remember if it was in Sheets or OpenOffice, that would return a week number. Even that would work, as long as it would return less than whole numbers. I fiddled with it for a bit and got aggravated because somehow I couldn't get the syntax right.
Thank for the reply, Omar.
Adrian | |
|