I am trying to create a formula that would calculate every Tuesday of the month. If A1 is the first Tuesday of the month, cell B1 is A1+7, cell C1 is A1+14, etc. I want to account for the possibility that there is a 5th Tuesday in a month but do not what a result to show if there is only 4 Tuesdays. For example, if cell E1 has the formula A1+28 and returns 29, 30 or 31, fine; but if A1+28 returns a number 1 through whatever, to not show the result. I am trying to use an If statement, but not getting accurate answers.
Thanks,
Bookmarks