Does anyone have any suggestions on the following?
Date 1 is the date a document is created - this can be any day. From this date I can create a Weekday value.
I then have a second Weekday value, this can be any value from 1-7.
How can I work out the date of the second Weekday value, immediately following the first Weekday value i.e. if the first value is 4 (Wed) and the second value is 6 (Friday), how can I find the date of the first Friday immediately following the first value, bearing in the mind the 2 values are never contstant?
Hope this makes sense. Any suggestions would be greatly appreciated.