I think it would help to have an idea of the data, what makes an item
outstanding, etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mbparks" wrote in message
...
I am working on a spreadsheet that tracks when items are requested and
received.
Sheet 1 is the log.
Sheet 2 is a formula sheet. (This is where I need another formula.)
I have 12 sheets- individual monthly reportsfor the year.
Can someone please help me with a formula that will count the number of
items outstanding and calculate the age of the outstanding items as of the
last day of the month for the reports.