Thetownend.com

Right.  I have a list of about 300 invoices and their invoice dates.

I need to stick them into a bucket depending on how old they are.  e.g <30 days.  31-60 days etc

What formula can I use to do this??

Simplest way would be to stick another column in, add the formula =TODAY()-A1 (or whatever your cell reference is) to work out the number of days between the two dates, then just use the filter.

I go for a slightly less-elegant solution in my work:

I have today's date in cell A1:  =TODAY()

Then in column B I have the bins similar to what you're talking about, Column C is the invoice date.

So the formula:

=IF($A$1-C4<30,"<30 days",IF($A$1-C4<61,"31-60 days",IF($A$1-C4<91,"61-90 days",">90 days")))

Where $A$1-C4 is today's date minus invoice date. Obviously change $A$1 to wherever today's date is, and C4 to the first invoice date

The idea being, if it's less than 30 days, display "<30 days", if not, move on to the next one, if it's more than 30, less than 61, display "31-60 days", if not, move on...

You can have as many bins as you need by following that structure...

Thanks. Both interesting.  Either way they would give me the bucket and I would just need to copy across the invoice value.

I'd use the DATEIF formula to return the number of days from today in a new column. Then create a pivot table based on all the data. Within the pivot table you then have the option to group the data which you could group in intervals of 30 (days).

But then again I do like pivot tables a bit too much.