A1: holds date

B1: =A1-MOD(A1-2,7)+(WEEKDAY(A1)<2)*7
B2: =B1+3+(WEEKDAY(B1+3)<2)

copy from B2 down to B10


"Annie99" wrote:

How do I count the next 10 days from a given date? But only if they were
Mondays and Thursdays? In the example below, I want to count the 10 Mondays
and Thursdays from 1st October.

For example:

A1 = Mon B1 = Thu

A2 = 01/10/2007 B2 = 10