I would like to count specific transactions in progress on specific dates.
Each transaction will have different start and closing dates. For example,
1/1/05 may be a start date with 1/5/05 its close; and another starts 1/2/05
with 1/15/05 its close, thus on 1/3/05 I would have two open transactions.
Each row in my sheet is a separate transaction and a column is dedicated for
the open and one for closing date. I have apx. 39,000 transactions to count
over a ten year period.