Thread: Every 1st, 3rd, 5th Tuesday
View Single Post
  #4   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 Mon, 11 Jun 2007 22:10:24 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

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

+14 ???

Rick

Duh, of course <hand slapping forehead
--ron
Reply With QuoteReply With Quote