threeleftfeet
Offline
Posts: 22
|
|
« Reply #2 on: Monday, August 18, 2014, 15:56:34 » |
|
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...
|