Column A "Date Received"
Column C "Priority" is validation list with options P1-P6
Column D "Due Date"
.. How do I make Column D calculate the due date, based on which option is selected in Column C in conjunction with the date in Column A?
PI = Date Received
P2 = Date Received
P3 = Date Received + 1 day
P4 = Date Received + 5 business days
P5 = Date Received + 14 business days
P6 = Date Received + 30 business days
Solved by D. U. in 14 mins