HELP - Number of items between dates

Ok here is my problem....

I have a column of dates that I want to be able to report on. The date ranges are between 2002 and 2008. They are warranty expiration dates for servers.

I need to be able to report on 3 items.

1 - How many warranties have expired?
2 - How many will expire between today and 60 days from now.
3 - How many will expire in more than 60 days from now.

Thanks for any help on this.

Swervy

Try the following...

1 - How many warranties have expired?

=COUNTIF(A1:A100,"<="&TODAY())

2 - How many will expire between today and 60 days from now.

=SUMPRODUCT(--(A1:A100>TODAY()),--(A1:A100<=TODAY()+60))

3 - How many will expire in more than 60 days from now.

=COUNTIF(A1:A100,">"&TODAY()+60)

Hope this helps!

Domenic,

All 3 worked like a champ.

I had actually figured out #1, and was close on #3, but number #2 was a complete mystery to me.

Here is what my final formula ended up looking like...

=SUMPRODUCT(--('Active Servers'!$AO$2:$AO$995>TODAY()),--('Active Servers'!$AO$2:$AO$995<=TODAY()+60))

Thanks again for the quick response and the excel lent(ok a really bad pun) help with this.

Swervy