View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Every 1st, 3rd, 5th Tuesday

On Tue, 12 Jun 2007 09:34:10 +0800, Rick wrote:

Hi,

I have a start date of 2 Jan 07 in A1 - the 1st Tuesday of the month.

How can I get the cells below populated with the dates of the 1st, 3rd
and 5th Tuesdays of every month?

Tks, Ricky


A2: =A1+7

Fill down as far as required.
--ron