AgTalk Home
AgTalk Home
Search Forums | Classifieds (188) | 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
 
Omar
Posted 11/17/2016 20:55 (#5641949 - in reply to #5641900)
Subject: RE: Google Sheets spreadsheete date help


Elmira, Ontario

If your date is in A1, then this should work. Note I put 0 in the day spot of the DATE function (basically goes to the last day of previous month which is December 31 to get the right number of days).

=DAYS(A1,DATE(YEAR(A1),1,0))

edit to add screen shot:



Edited by Omar 11/17/2016 21:00
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)