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.