Thread: Formula to Return the next 1st Tuesday of a Month
View Single Post
  #31   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Formula to Return the next 1st Tuesday of a Month
On Sun, 2 Dec 2007 02:54:29 -0800 (PST), Harlan Grove
wrote:

Then you could use a simpler formula. For the date/time in A3,

=INT(A3-WEEKDAY(A3-1.5,2)+7*MATCH(TRUE,DAY(A3-WEEKDAY(A3-1.5,2)
+7*{1;2;3;4;5}+0.5)<8,0)+0.5)+0.5

Very Nice, Harlan.
--ron
Reply With QuoteReply With Quote