I have a date field called CloseDate in Opportunity Object and the Date of Opportunity set it as 05/26/2016. I want a formula field or any logic to get the Date of the Saturday of same week(In the above date case it should be 05/28/2016).
The date should generate based on CloseDate .One more examaple, If I give the close date is 05/17/2016 then the Logic field should display the date as 06/21/2016
I tried different ways but it didn't work. Below are one of my trials
DATE(YEAR(TODAY()), MONTH(TODAY()), CASE(MOD(DATE(YEAR(TODAY()),MONTH(TODAY()),1) - DATE(1900, 1, 7), 7), 0, 2, 1, 1, 2, 7, 3, 6, 4, 5, 5, 4, 6, 3, 0) )
Ans: Its giving first Monday Date of a Month
Any help will be really helpful