Thread: Count number of dates older than 30 days

Hey everyone,

I'm new-ish to using Excel, but I do have a good grasp on the basics. I need to figure out how to tell Excel to count the number of invoices on a worksheet older than 30 days and display that number in my Summary worksheet. Here's a quick example:

Worksheet '1234' has 10 invoices, 6 of which are more than 30 days old (invoice dates are in column B).

Worksheet 'Summary' needs to display the total number of invoices and the number older than 30 days.

Any help would save me HOURS of work a week and would be greatly appreciated.

Travis Hill
Altaquip - St Louis, MO

Try

=Countif('1234'!B1:B10,"<"&Today()-30)

where B1:B10 is your range on invoice dates.