Forum Discussion
Mark
Hi trying to find last wednesday of month where thursday is not new month
Alternatively:
=EOMONTH(A1,0) - WEEKDAY(EOMONTH(A1,0),14)Here are the 3 options tested on April and Sept of 2026 where the last day of the month is on a Thurs and a Wed respectively:
As I can see, your formula is better than mine (more shorter), so I suggest the OP use your solution.
Have a nice day.
IlirU