Extract Day logic

Hi All ,
I am reading cell from excel which gives me date as Sunday, December 13,2020
I need the BOT to check that if the Day is Sunday then BOT should assign value of Monday to the variable in the format “12/14/2020” and if the day is Saturday i.e. Saturday, December 12,2020" then BOT should assign the Friday date into the variable in the format “12/11/2020”
Can anyone help in this logic?