Good afternoon. I can not find a solution. I used to know how to do this, but am drawing a blank.
Hopefully this is a simple solution. I want to take a specified date and convert it to the Friday of that week. The week starts on Monday and goes through Sunday.
Our weeks are Mon through Sun. If the date falls after Friday, and is Sat or Sun, it needs to refer back 1 or 2 days to Friday.
So, any date from Monday, September 21 - Sunday, September 27, I need it to display as September 25th. and so on for each week of the year.