Formula to Return the next 1st Tuesday of a Month
On Sat, 1 Dec 2007 11:31:09 -0800 (PST), Sean wrote:
Wow thats a helluva formala guys, Thanks
As Rick pointed out, my formula is flawed.
This one should work, though, I think:
=IF(A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)-2)A1,A1-DAY(
A1)+8-WEEKDAY(A1-DAY(A1)-2),DATE(YEAR(A1),MONTH(
A1+1),8)-WEEKDAY(DATE(YEAR(A1),MONTH(A1+1),6)))
--ron
|