Calculate the 4th Wed of every Month

[John1953]

Some time ago, I received help with this subject. This formula

=DAY(WORKDAY.INTL(EOMONTH(TODAY(),-1),4,"1101111"))

Works great, but only returns a date for the current month, how can I have it apply to future months?

 

[Eric W]

=DAY(WORKDAY.INTL(EOMONTH(TODAY(),-1),4,"1101111"))

Use -1 to get the 4th Wednesday of this month, 0 for the 4th Wednesday of next month, 1 for the 4th Wednesday two months out, etc.

 

[John1953]

Thanks for the assist, works great!

 

[Peter_SSs]

Works great, but only returns a date for the current month,

As I'm sure you are aware, it actually only returns the day number, not the actual date.
I am wondering if you are then combining with month & year to get a series of actual dates?
If so, and you want a list of dates being the 4th Wednesday of a number of months starting this month, you could adapt the formula like this. In the formula I have used 12 in the SEQUENCE function. That is the number of months to produce the dates for, so edit that value if you want more or less months.
(Sorry if I have gone down a completely wrong path )

24 01 07.xlsm
	D
1	4th Wednesdays
2	Wednesday, 24 January 2024
3	Wednesday, 28 February 2024
4	Wednesday, 27 March 2024
5	Wednesday, 24 April 2024
6	Wednesday, 22 May 2024
7	Wednesday, 26 June 2024
8	Wednesday, 24 July 2024
9	Wednesday, 28 August 2024
10	Wednesday, 25 September 2024
11	Wednesday, 23 October 2024
12	Wednesday, 27 November 2024
13	Wednesday, 25 December 2024
List 4th Wednesdays

Cell Formulas
Range	Formula
D2:D13	D2	=WORKDAY.INTL(EOMONTH(TODAY(),SEQUENCE(12,,-1)),4,"1101111")
Dynamic array formulas.

 

[John1953]

Thank everyone for help, got several now to choose from. I have things up and running smooth now.