Friday, February 19, 2016

yogi_Compute How Many Dates In Column A Fall Within Last 7 Days 30 Days 90 Days

Google Spreadsheet   Post  #2040
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-19-2016
post by: Gary needs help please:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/Jjgbjtkw0XI
Counting a Date Range
Column A is the date
Column B returns the information
I want column B to tell me how many dates in Column A happened within the last week, month etc.
so for example:
20/02/2016
19/02/2016
10/02/2016
18/02/2016
11/02/2016

Column B should tell me 3 with the above example since 3 dates happened within the last 7 days.
----------------------------------------------------------------------------------------------------------------