Work week is Monday through Sunday. Settlement pay is paid every Friday for what was completed the previous work week. I need a function that will display in Creator form what that next Friday Settlement Date is expected to be based on the Delivery Date entered.

Example 1

Delivery Date: Monday 5/30/2022

Expected Settlement Date: Friday 6/10/22

Example 2

Deliver Date: Sunday 5/29/22

Expected Settlement Date: Friday 6/3/22

Thank you!!!