Thread
:
Formula to Return the next 1st Tuesday of a Month
View Single Post
#
32
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)
external usenet poster
Posts: 2,202
Formula to Return the next 1st Tuesday of a Month
=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
<APPLAUSE
<APPLAUSE
<APPLAUSE
<APPLAUSE
Rick
Reply With Quote
Rick Rothstein \(MVP - VB\)
View Public Profile
Find all posts by Rick Rothstein \(MVP - VB\)