Forum Discussion
Mark
Hi I am trying to return last wednesday of month but not followed by new month
1 Reply
=LET( lastDay, EOMONTH(A1,0), lastDayWeekday, WEEKDAY(lastDay,2), daysToSubtract, MOD(lastDayWeekday - 3, 7), lastDay - daysToSubtract )
If you're using Excel 365 or Excel 2019 with the LET function available.
Not compatible with older versions of Excel that don't support the LET function.
WORKDAY.INTL (Excel 2010+)
=WORKDAY.INTL(EOMONTH(A1,0)+1, -1, "1101111")
Requires Excel 2010 or later. The string argument "1101111" specifies that only Wednesday is considered a workday, which might not be immediately clear to all users without referencing the function's documentation.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
