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!

Genevieve P.

Hi Kylie,

Glad you got it sorted out! If you wanted to post your solution here it may help other users looking for a similar formula.