Let me clarify further. I have a spreadsheet that has a worksheet with over
100 items that sort into three different categories, each with it's own
target date. I would like to have another worksheet that would show me the
number of items in category A, B, and C that have a target dates of 15 days
or less from todays date. I would further like to capture the cound of
those due between 15 days and 30 days from today. 31 and 40, 41 and 60. I
hope this helps a bit.

"Sandy Mann" wrote:

That would count every date before 15 days ago I think that you may mean to
count dates in the lastr 15 days. If so try:

=SUMPRODUCT((Sheet1!A1:A25TODAY()-16)*(Sheet1!A1:A25<TODAY()))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
Try somethong like:

=COUNTIF(Sheet1!A1:A25,"<"&TODAY()-15)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"fluffy" wrote in message
...
I have a spreadsheet that has a number of items in it. Each with their
own
due date. I would like to have another summary worksheet that shows me
the
number of items that are due within the next 15 days, 30 days, 45 days
and 60
days. I don't need to know the specific items just the count of the
items
due in these periods.