First Tuesday of the month - MORE
Posted by Brett on June 22, 2000 6:11 AM
I asked if anyone knew how to generate a series of dates in a column based upon the first Tuesday of the month.
The following was posted by Jaime as a fix:
=DATE(YEAR(K2),MONTH(K2)+1,1) - MOD(DATE(YEAR(K2),MONTH(K2)+1,1)-3,7)+7
Assuming starting date is in cell K2 (does not have to be a tuesday).
Well this ALMOST works. The problem is that if the first Tuesday is the 1st (as in May 1st 2001), the above returns a date of the 8th!