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
Tagged:
0
Best Answer
-
IF WEEKDAY(END()) > 5 THEN END() - (WEEKDAY(END()) - 5) ELSE END()0
