Statement to read a text in one cell, then add a numeral (based on the text) to the date in another

Kylie English

Hi all, help please :)

I have 3 columns -

Approval Due Date

Requested Date

Priority

Step 1 - Approval Due Date to look at the Priority

Priority will be High, Moderate or Low / High = 7 days /Moderate = 14 days / Low = 21 days

THEN

Look at the Requested Date column and add the number of days relevant to the priority rating onto the Requested Date to get the Approval Due Date.

I have tried many things and failing lol. THANK YOU!

Kylie English

Ok I finally managed to sort this one out, no need to answer thank you!