Last work day of month

Highlighted
Previous Contributor

Last work day of month

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

1 REPLY 1
Highlighted
Community Boss

RE: Last work day of month

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