Last work day of month

[PrevContributor]

Dear all, is there a function enabling to show the last work day (ending on Friday) of each month (date formatted), e.g. last work day of July 2016 would be 29/07/2016? Thanks a lot in advance for your feedback. Best regards Timo

[ChrisMullen · Accepted solution]

IF WEEKDAY(END()) > 5 THEN END() - (WEEKDAY(END()) - 5) ELSE END()