With the invoice date in A1 try:

=IF(OR(A1="",A1=TODAY()),"",IF(DATEDIF(A1,TODAY() ,"y")0,
"Over 1 year","Aged "&TODAY()-A1))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Grd" wrote in message
...
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