AgTalk Home
AgTalk Home
Search Forums | Classifieds | Skins | Language
You are logged in as a guest. ( logon | register )

Google Sheets spreadsheete date help
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
Adrian
Posted 11/17/2016 20:38 (#5641900 - in reply to #5641837)
Subject: RE: Google Sheets spreadsheete date help



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
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)