I want to create a formula date field for client payments when the job completion date is entered. How can I calculate if the [Task Completion Date] is on a Monday, Tuesday, or Wednesday, then the date should be Friday of that same week. If the date is on a Thursday or Friday then the date should be the Friday of the following week. Searched for ideas but couldn't find anything. Any assistance would be much appreciated. Thanks!