View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick[_3_] Rick[_3_] is offline
external usenet poster
 
Posts: 11
Default Every 1st, 3rd, 5th Tuesday


Geez, I feel very embarrassed to have posted that question!

Thanks Ron/Rick for your responses.

Ricky
(smacking his forehead after realizing the solution)

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