Hi all,
I am trying to work out a formula to get a cell to return a date based on a dropdown value.
I need the cell to tell me when a matter is due, based on when the matter was received and the priority rating.
the priority levels are (Service Type):
- Fast track - 7 days
- Basic - 14 days
- Standard - 30 days
- Complex - 60 days
- Complex Advertising - 90 days
I have a column with the date the matter was received, and I need another cell in the same row to show the due date based on the above priority rating..I can get this to work with the following formula, but cant figure out how to get it to work if a different priority level is chosen 
=IF([Service Type]1 = "complex advertising - 90 days", [Date Received]1 + 90)
Any help would be greatly appreciated!