Way to calculate the 2nd Wednesday of every month?

[charlesstricklin]

I would have sworn that I had already asked and had wonderfully answered, but I can't locate it so, I'll ask again. Is there an equation to yield the 2nd Wednesday of every month based on the cell/month above it?

I.e.

I know that I can't click and drag my way to answer. It's probably something easy and I'm just missing it.

 

[awoohaw]

try this:

NOTE: 1/8/2024 and 2/12/2024 are mondays, not wednesdays.

Book1
	A	B
1
2	Wed 2024-06-12
3	Wed 2024-07-10	Wed 2024-07-10
4	Wed 2024-08-14	Wed 2024-08-14
5	Wed 2024-09-11	Wed 2024-09-11
6	Wed 2024-10-09	Wed 2024-10-09
7	Wed 2024-11-13	Wed 2024-11-13
8	Wed 2024-12-11	Wed 2024-12-11
9	Mon 2024-01-08	Wed 2025-01-08
10	Mon 2024-02-12	Wed 2024-02-14
Sheet1

Cell Formulas
Range	Formula
B3:B10	B3	=WORKDAY.INTL(EOMONTH(A2,0)+7,1,"1101111")

 

[Fluff]

Another option

Fluff.xlsm
	A
1
2	12/06/2024
3	10/07/2024
4	14/08/2024
5	11/09/2024
6	09/10/2024
7	13/11/2024
8	11/12/2024
9	08/01/2025
10	12/02/2025
Data

Cell Formulas
Range	Formula
A3:A10	A3	=WORKDAY.INTL(EOMONTH(A2,0),2,"1101111")

 

[charlesstricklin]

My apologies for the late reply. Life sort of took over. Thank you to Fluff & awoohaw for the replies.

 

[Fluff]

Glad we could help & thanks for the feedback.