Hi Pete,

tx for your reply
Its exactly how BonM has it above which is great. 30 to 60 it is aged 30 etc

tx
s

"Pete_UK" wrote:
http://www.microsoft.com/wn3/aspx/po...l&sdgloc=en-US
Do you mean if the invoice is more than 30 days old, but less than 60 you
want to show Aged 30, or does this apply to any invoice up to 30 days old?
(Sorry, I'm not an accountant).

Pete

"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