Can I do this in Excel?

B

Bethany

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?
 
T

Tonto

Bethany said:
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?
Click to expand...

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
 
Top