Formula to Calculate the Last Wednesday of Each Month

[dsami0122]

Example: If Column B is the Start Date is the Month 12 of the year how would it calculate the date 12/25/2024 using a formula

 

[awoohaw]

I don't understand your title compared to your question. But try this:

=WORKDAY.INTL(EOMONTH(B2,0)+1,-1,"1101111")

Book1
	B	C
1
2	2024-12-01	2024-12-25
Sheet2

Cell Formulas
Range	Formula
C2	C2	=WORKDAY.INTL(EOMONTH(B2,0)+1,-1,"1101111")

 

[Dave Patton]

Dates and Time 2024.xlsm
	A	B
1
2	05-Dec-24	25-Dec-24
3
3bbb

Cell Formulas
Range	Formula
B2	B2	=WORKDAY.INTL(EOMONTH(A2,0)+1,-1,"1101111")

 

[dsami0122]

Thank you that worked