Creator.. How to get the next Friday date?

Creator.. How to get the next Friday date?

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!!!
    Zoho Marketing Automation

              Zoho Pagesense Resources

                Zoho SalesIQ Resources



                      Zoho TeamInbox Resources

                        Zoho DataPrep Resources



                          Zoho CRM Plus Resources

                            Zoho Books Resources


                              Zoho Subscriptions Resources

                                Zoho Desk Resources

                                  Zoho Projects Resources


                                    Zoho Sprints Resources


                                      Qntrl Resources


                                        Zoho Creator Resources


                                          Zoho WorkDrive Resources




                                              Zoho Campaigns Resources

                                                Zoho CRM Resources

                                                        Design. Discuss. Deliver.

                                                        Create visually engaging stories with Zoho Show.

                                                        Get Started Now