Calculate future date based on dates of past events.

I work for several contractors which have different payroll periods ranging from Sunday through Saturday, Monday thru Sunday, Friday thru Thursday, etc. Each contractor pays on a subsequent Friday depending on which day of the the week I worked. For example I worked for contractor "A" during a given calendar week (Sunday thru Saturday) on Thursday. Payment from contractor "A" whose payroll period is Monday thru Sunday would be on Friday next. That same calendar week I also worked for contractor"B" on Saturday. Payment from contractor "B" would not happen on Friday next but two Fridays away because even though it was the same calendar week, it was in a subsequent payroll period for that contractor. When entering the date worked in Excel for a given contractor I want Excel to automatically calculate the appropriate pay date given the contractors unique payroll period. I use this worksheet for budgeting purposes.

Need help to upload file. Where is the link or instructions?

Book1.xlsx

Thanks, works perfectly.