Calculating a date based on three criteria
I'm trying to create a spreadsheet that will calculate a future date based on three criteria.
Entity name is column A
Their model is column B, and there are three options in a drop down menu.
A further subtype is categorised in column C, three options, two options in a drop down menu.
A further subtype is categorised in column D, two options in a drop down menu.
Last visit is column E.
Future visit is in column F, which is what I want to calculate.
In this example:
All small business pet shops are visited every 12 months if they sell only cats.
For corporates, this is every 24 months.
If an entity sells dogs, they are visited twice as often.
And if they sell baby animals, they are visited twice as often again.
How can I calculate when the next visit is due?
Apologies for the pet shop example. Rescue from your local shelter or contact a responsible breeder!
[link] [comments]
Want to read more?
Check out the full article on the original site