I have 3 Date fields and 1 text field
I entered current date in start_Date and inserted a date from december 2018 on End_Date. If Category field = "DJ" the Celebration_Date automatically enter the upcoming date of the saturday and if If Category field = "Rock" the Celebration_Date automatically enter the upcoming date of the Sunday. and if If Category field = "work" i could manually enter any date i want.
which means for a time period of months i need Celebration_Date to show automatically the dates of upcoming saturday and sunday based on the value in Category Field. Also the Celebration_Date is capable of recieving manual entry if the Category has another value besides DJ and Rock! The Dates of upcoming saturday and sunday automatically update right after the previous saturday and sundays are over!