Thread: Formula to Return the next 1st Tuesday of a Month
View Single Post
  #14  
Old December 1st, 2007, 10:48 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, 01 Dec 2007 17:43:49 -0500, Ron Rosenfeld
wrote:

In any event, modified:

=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)))

Oh, and I interpreted the OP's request for the "Next" Tuesday to mean that if
TODAY is a Tuesday, the "Next" Tuesday would necessarily occur in the future.
--ron

This is wrong, too.
--ron