Hi y'all,

For work, I have to make an idea- & to-do list. Short description: someone has to fill in a concept, the date of entry, and priority: high, medium, low. Based on the priority, we want to give it a timeslot so we can take it into a meeting.

We would like to give the values:

High = 48 hrs
Medium = 7 days
Low = 14 days

E.g. employee A filled in a concept on 21-01-2021 with high priority. Therefore, we want it in our agenda sheet with the date: 23-01-2021.

Which formula should I use?