First Tuesday of the month

Posted by Brett on May 23, 2000 6:45 AM

I want to do a series fill on a column, such that each date is the first Tuesday of the month....

Tue 4 Jan 2000
Tue 1 Feb 2000
...
How can I get Excel to continue the series down?

Posted by Jaime on May 23, 2000 9:36 AM

=DATE(YEAR(K2),MONTH(K2)+1,1) - MOD(DATE(YEAR(K2),MONTH(K2)+1,1)-3,7)+7

Assuming ur starting date is in cell K2 (does not have to be a tuesday).

Posted by Brett on May 24, 2000 1:05 AM

Thanks Jaime
My semi-solution was to create a list of Tuesdays and then use an "IF then" command to extract the first Tuesdays. Your solution is much more elegant.

Brett