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:
Any help would save me HOURS of work a week and would be greatly appreciated.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.
Travis Hill
Altaquip - St Louis, MO
Bookmarks