Hi,

I am trying to find a formula that will allow me to choose a day of the week from a drop down list and then automatically populate the following days of the week, in order, in other cells.

For example, if I choose Tuesday in cell D106, I would like Wednesday to appear in cell 110, Thursday in cell 114, Friday in cell 118 and so on. If possible I would also like to make it dependant on the number of days that I have entered in another cell. To add to the example, if I enter 7 days in cell B106 and choose Tuesday in cell D106 then every 4th cell in column D should have the next day of the week until we arrive at Monday. If I enter 8 days it would stop at Tuesday, if I enter 9 days, Wednesday, and so on.

Is that possible without using a Macro?

Many thanks in advance,
Scott