"Dave" wrote:

Hi,
If your initial price is in, say, D10, and
If your initial received date is in, say, C10

then in another cell:

=IF(C10="","",IF(C10<(TODAY()-90),D10*0.7,IF(C10<(TODAY()-60),D10*0.8,IF(C10<(TODAY()-30),D10*0.9,D10))))

This will give you the price as you want, changing automatically as the
initial date becomes over 30, then 60, then 90 days old.
Is this what you need?

You can probably just fill across or down for other columns, but I would
have to know the layout of your sheet to be sure.

Regards - Dave.
Thanks again!
Right now the sheet is set up as a table with columns labeled: Item#, Item,
Date In, Price, Date +30, Price -10%, Date + 60, Price - 20%, Date + 90,
Price-30%, Date Sold.
The rows will be used for listing the customer's merchandise. This is for a
consignment store. The sheet will be used for tracking each customer's item
as they are added to inventory. Thanks for your help!!!