I have a requirement where i need to calculate last 10 week ending dates of the week(Saturday) and the future Week end dates of the current year in a drop down on new form load.
I have the calculation for SP column to get current week end date as "=Today-WEEKDAY(Today,3)+5"
Is there a way where i can loop through previous 10 week end dates and then next week end dates by subtracting and adding 7 to current week end dates through JS?
What function can i use to calculate. I'm a beginner in JS.