Formula(s) to detect and display first Wednesday of current month

[FrancisXSlaughterry]

I need to detect and display the date of the first Wednesday of the current month in a cell.

What formula(s) do I need to create to do this?

Thanks in advance,

Francis X.

[Marcol]

Try this as a general function for first Wednesday in given month.

=DATE(YEAR(A1),MONTH(A1),1)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),4))+7

And for the current month

=DATE(YEAR(TODAY()),MONTH(TODAY()),1)-WEEKDAY(DATE(YEAR(TODAY()),MONTH(TODAY()),4))+7

Hope this helps.

[EDIT]
Accidentally left an unrelated macro in the workbook.
Took the oppertunity to add DLLs' solution to this attachment.

[FrancisXSlaughterry]

That works perfectly. Thank you! I also appreciate that you posted the file. Excellent stuff.

[daddylonglegs]

given that you can get first day of the month with A1-DAY(A1)+1 you could also shorten that formula to this version

=A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)+4)

[Marcol]

Happy to help.

You might find this link and its' related links useful
Worksheet Functions For Dates And Times