I need help to create a function, I am trying it, but I confess that I am lost.
The function works with date, then imagine you have a formatted date like 20/12/2019 (dd/mm/yyyy)
I want to add 40 days on it or any days ahead (30, 70, 84, etc days), until here it is fine for me and I can do that, very easy.
Now, this part is my problem, I have a list of possible day that my date must be, for example 3,6 ( Tuesday and Friday), if my date
after added 40 days ahead gets on Saturday or Sunday or Monday, it must be placed on Tuesday.
If my date is on 4, 5 ( Wednesday or Thursday) it must be placed in Friday;
The rule of my string possibles days can be change, today I work with 3,5 but in the future, it must be in 2,7.
I thank a lot any help