Sunday, July 8, 2012

yogi_Count Submissions By Such Things As Date Week Month Year And Hour

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #617   Jul 8, 2012     www.energyefficientbuild.com.


user SN1173 said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/0cuqZzM6U-Y)
How can i count unique dates from a list of time stamps
Every time I fill out my form, it has a timestamp for the entry.  I want to count the number of unique dates from the spreadsheet.  Because it has a time with the date, it counts each entry as unique.  Is there a way to only count unique dates?
--------------------------------------------------------------------------------------
following is a more generalized solution where I have counted submissions by 
  • Date
  • Week and Year
  • Month and Year
  • Year
  • Hour of Day Month and Year