I keep record of client's orders by name, date, dollar amount and so forth,
per month. I'd like to be able to keep track of the clients who have not made
an order in over 6months to a year. Is there a formula for this?

Bethany wrote:

I keep record of client's orders by name, date, dollar amount and so forth,
per month. I'd like to be able to keep track of the clients who have not made
an order in over 6months to a year. Is there a formula for this?

If you have a start date then you can set a "contact again" cell based
on that date eg date+182 days.

For help with dates Chip Pearson has a superb set of Topics at
http://www.cpearson.com/excel/topic.htm


Jp