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
Sorry, my first answer was incorrect.
Try this:
=A1+7+7*(MONTH(A1+7)=MONTH(A1))
--ron
|