Find next Friday (or find next day of week)

3

…unless it’s already Saturday and it will show the previous one.

Correct one would be:

YourDate + Remainder(13 - YourDate.Weekday(), 7)

if it should show the same day on Friday, and

YourDate + Remainder(12 - YourDate.Weekday(), 7) + 1

if it should show the next one.

5 Likes