View Single Post
  #8   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 11:08:57 +0800, Rick wrote:


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


Best to check my last answer.
--ron