List of 3rd Wednesdays of each month
11,216
In A3 I put the first month I want, I put 1/1/2016.
Then in C3 I put this formula:
=DATE(YEAR(A3),MONTH(A3),22)-WEEKDAY(DATE(YEAR(A3),MONTH(A3),4))
Then under C3 in C4 I put:
=DATE(YEAR(C3),MONTH(C3)+1,22)-WEEKDAY(DATE(YEAR(C3),MONTH(C3)+1,4))
Then drag down.
Author by
evilrod
Updated on June 05, 2022Comments
-
evilrod almost 2 years
I'm trying to find the formula to automatically generate the Third Wednesday of Each month.I searched and found this:
=LOOKUP(A3,DATE(YEAR(A3),{0,3,6,9,12;3,6,9,12,15},22)-WEEKDAY(DATE(YEAR(A3),{0,3,6,9,12;3,6,9,12,15},4)))
Where my first Wednesday is in A3. However this formula only give the results for 3, 6, 9 and 12 months. Would anyone please give me a formula to get all year 12 months and keep going to the following year if I drag down.