Is your date in A2 always a Monday? If not, how do you want compute the
first Monday, the Monday following your date or the Monday preceding your
date?

"Annie99" wrote in message
...
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