Forum Discussion
Mark
Hi trying to find last wednesday of month where thursday is not new month
Hello MarkBeck54,
Use the formula =EOMONTH(A1,0) - WEEKDAY(EOMONTH(A1,0)-3,1) where A1 contains any date in the month. This returns the last Wednesday whose following Thursday is still in the same month.
Thank you works a treat
