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
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
No comments:
Post a Comment