Thread: Formula to Return the next 1st Tuesday of a Month
View Single Post
  #15  
Old December 1st, 2007, 10:58 PM posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
external usenet poster
  
Posts: 3,719
Default 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


Sean,

This one works, I'm fairly certain:

=IF(A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)-2)A1,A1-DAY(
A1)+8-WEEKDAY(A1-DAY(A1)-2),A1-DAY(A1)+40-DAY(A1-DAY(
A1)+32)-WEEKDAY(A1-DAY(A1)+30-DAY(A1-DAY(A1)+32)))


--ron