Thread: counting dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default counting dates

On Mon, 8 Oct 2007 12:04:04 -0700, 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


Your question would be more clear to me if you also gave the result you expect
from this calculation.
--ron