Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a list of articles and weekdays they arrive.
Example:
Article | ArrivalDay 1 | ArrivalDay 2 |
---|---|---|
Article1 | Monday | Friday |
Article2 | Wedensday | Friday |
Article3 | Monday | Tuesday |
Article4 | Tuesday | Thursday |
Today is 20-03-2013, and I wonder if there is any way to convert the weekdays to Dates... The date should be the first upcoming date (or todays date) that matches the weekday.. euhm.. my bad english makes it hard to explain
Anyway, result that I want is this:
Article | ArrivalDate 1 | Arrival Date 2 |
---|---|---|
Article1 | 25-03-2013 | 22-03-2013 |
Article2 | 20-03-2013 | 22-03-2013 |
Article3 | 25-03-2013 | 26-03-2013 |
Article4 | 26-03-2013 | 28-03-2013 |
Any help is appreciated
thanks in advance.
See attached example
Thanks you so much, that´s awesome!
I haven´t really figured out how it works yet but hopefully I will