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

**FrancisXSlaughterry** · 06-05-2011, 06:58 AM

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** · 06-05-2011, 08:13 AM

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

Please Login or Register  to view this content.

And for the current month

Please Login or Register  to view this content.

Hope this helps.

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

**FrancisXSlaughterry** · 06-05-2011, 09:00 AM

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

**daddylonglegs** · 06-05-2011, 09:06 AM

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)