K
keith0628
I have a list of records about which I'm trying to summarize differen
information. One of the columns in the spreadsheet is a created date.
What I want to do is create three summary fields, one that shows a coun
of the records from today to six days ago, a second field that shows
count of all records from seven to 14 days ago and the last fiel
showing a count of all records over 15 days ago. This sheet will b
updated regularly, so I don't want to have specific dates in m
formulas. I used the COUNTIF function to do summarization for
different part of the spreadsheet, but I can't figure out how to get i
to work for date ranges.
Any suggestion would be helpful
information. One of the columns in the spreadsheet is a created date.
What I want to do is create three summary fields, one that shows a coun
of the records from today to six days ago, a second field that shows
count of all records from seven to 14 days ago and the last fiel
showing a count of all records over 15 days ago. This sheet will b
updated regularly, so I don't want to have specific dates in m
formulas. I used the COUNTIF function to do summarization for
different part of the spreadsheet, but I can't figure out how to get i
to work for date ranges.
Any suggestion would be helpful