RockNGoalStar
New Member
- Joined
- Nov 4, 2022
- Messages
- 5
- Office Version
- 365
- Platform
- MacOS
Hi All,
I am trying to work out a formula that will show me whether a customer's last order with me was within the last 3 months. I have a column with dates of their last order (F).
So, essentially I would like to ask IF this date occurred more than 3 months ago from TODAY's date then then the customer is Lapsed. if it was within the last 3 months then the customer is current.
If someone could help me with that, then I would be really grateful!
As an additional complication, but not wholly necessary if too much trouble, but would it be possible to work out customers who hadn't ordered for even longer, e.g. 6 months, and they would be Super Lapsed.
Many thanks in advance
I am trying to work out a formula that will show me whether a customer's last order with me was within the last 3 months. I have a column with dates of their last order (F).
So, essentially I would like to ask IF this date occurred more than 3 months ago from TODAY's date then then the customer is Lapsed. if it was within the last 3 months then the customer is current.
If someone could help me with that, then I would be really grateful!
As an additional complication, but not wholly necessary if too much trouble, but would it be possible to work out customers who hadn't ordered for even longer, e.g. 6 months, and they would be Super Lapsed.
Many thanks in advance