Share via

FOURTH WEDNESDAY OF THE MONTH as a DATE formula in EXCEL

Tom Mick 20 Reputation points
2025-08-25T17:56:50.0066667+00:00

How to create a Date formula for the FOURTH WEDNESDAY OF THE MONTH? For example, the 4th Wednesday of August 2025 = 8/27/25.

Microsoft 365 and Office | Excel | For home | Windows
0 comments

Answer accepted by question author

  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2025-08-25T18:06:13.35+00:00

    You can use

    =WORKDAY.INTL(DATE(2025, 8, 0), 4, "1101111")

    2025 and 8 are the year and month, of course, and 4 specifies the 4th instance.

    The string "1101111" has a 0 in the position of the day of the week you're looking for, and 1s in the other 6 positions; the first position corresponds to Monday, the second to Tuesday etc.

    3 people found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.