Calculate next Scheduled Service date based off a regular schedule

Welcome to the forum and congratulations on providing a good subject.

A word of advice, you will probably get more responses if you attach a sample workbook with enough data to demonstrate what you are trying to do. Also sometimes it helps if you can mock up what your want the end result to look like and explain the steps you took to get from the raw data to one or two of the desired results.

Also, looking at the picture, I'd advise a more "flat" layout for the data.

Take a look at the sample workbook I've provided.

It consists of a table of customers and the days of the week that they get deliveries. I have a calculation table in Columns F:H. Column G contains the date for the day of the week in the current week. Column H looks at these dates, and if the date has already passed this week, it adds 7 days meaning that the delivery will be next week. If the day of the week had not yet passed, then a delivery will be made on that day this week.

I use a VLOOKUP in the table in columns A:C to get the next delivery dates.

Then I have two pivot tables:

The one in column J shows the date and which customers get deliveries on this date.

The one in column L shoes the customers and the dates on which they get deliveries.

The "flatter" you can make your data, the more you can do with it.