Perfect and a very elegant formula

Tx
S

"BoniM" wrote:

=HLOOKUP(TODAY()-A2,{0,30,60,90,120,180,240,300,360;"","Aged 30","Aged
60","Aged 90","Aged 120","Aged 180","Aged 240","Aged 300","Aged Over 1
Year"},2)

This function will subtract an invoice date in cell A2 (adjust as needed)
from today. If it has been less than 30 days, it will display nothing in the
cell, if it has been between 30 and 59 days, it will display - Aged 30,
between 60 and 89 - Aged 60, etc.
Until 360 or over - Aged Over 1 Year.
If it's only close to what you were looking for, let me know...


"Grd" wrote:

Hi there,

I'm trying to create a formula that shows me the following based on the date
of invoice.

Aged 30
Aged 60
Aged 90
Aged 120
Aged 180
Aged 240 etc upto 360 then
Aged Over 1 year

This is a really tough if statement I think but I'm not so great at anything
other than basic if statements.

Any help would greatly appreciated.

Tx

Suzanne