I have to calculate a new date base on the "Period Format" information. If weekday number of original date is not matching with the weekday number of "Period format" I need to move the date to the next working date according to the weekday number of "Period format"
14.10.2015 (Wednesday) should be recalculated and result in next Tuesday (20.10.2015).
5.5.2015 (Tuesday) to become next Wednesday (6.5.2015).
If weekdays of both "Orig.Date" and "Period Format" are matching the date is not recalculated. This is an easy part but I have some problems in implementing the formula for the condition when weekdays are non-matching. Could anyone provide any hints please?