Formula for Date to Round to upcoming Fridays Date

CaraBart28

Good Morning,

I am looking for help in creating a formula that will automatically update to the following Fridays date. You will see in the screen shot below that we have the auto column for the date request form submitted. I am looking to have the ordered date automatically round to the Friday following the created date. So in the example below the created date is 10/9/23, and I would like for it to automatically round to 9/13/23, how do I make this happen?

Paul Newcome

Give this a try:

=DATEONLY([Date Request form Submitted]@row) + (6 - WEEKDAY(DATEONLY([Date Request form Submitted]@row))) + IF(WEEKDAY(DATEONLY([Date Request form Submitted]@row)) = 7, 7)