View Single Post
  #3   Report Post  
mbparks
 
Posts: n/a
Default

Very sorry. My internet is acting strange this afternoon. I did not see my
question nor the response posted so I posted the question again.
Thanks.

"mbparks" wrote:

I am building a spreadsheet to track items requested and the dates they return.
There are 2 categories of items tracked.
There a several sheets. 1 sheet is the log. 1 sheet contains all the
calculations that feed the reports on 12 individual sheets (monthly reports).
On the log I have a column that calculates the age of the outstanding items
(date requested to current date).
I need a formula for the reports that will give a count of the outstanding
items (no date received) categorized by their age (under/over 40 days old).