Monday, April 30, 2018

yogi_Count Service Calls For 'This Week' 'Last Week' 'This Month' 'Last Month' For Referenced Date

Google Spreadsheet   Post  #2440

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-30-2018

question by: DallasJosph Helou!topic/docs/AgbBXkVczb4;context-place=mydiscussions
Trying to count cells in a column today Between a time range

I am trying to count cells in a column for today between a time range like 08:00:00 and 16:30:00. 

I have managed to find the formula for  to count cells for today. How do add a time period? 

=COUNTIFS('Form Responses 1'!A:A,">="&TODAY(),'Form Responses 1'!A:A,"<"&TODAY()+1)

I am also looking for a way to count Cells for:
  • this week
  • this month
  • last week
Any help would be greatly appreciated. 

No comments:

Post a Comment