Thread: counting dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Annie99 Annie99 is offline
external usenet poster
 
Posts: 5
Default counting dates

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