Last Working Day of Every Month Excludes Holidays

[sakthi266]

Hi Folks,

                Good evening. Hope all doing good.

                 I want to show the Last day of Working day for every month. For ex. For this Month 31-05-2018 , June -29-06-2018 . If June 29-06-2018 is holiday then 28-06-2018 . Please help ASAP

Thanks and Regards,

Sakthivel. S

[giovanneb · Accepted solution]

Hello,

Yes, it's possible.

vholidays = '08 / 01/2013 ', '09 / 01/2013', '15 / 01/2013 ';

LastWorkDate (max (ShipDate), 5, $ (vholidays))

Best Regards

[sakthi266]

Hi Giovanne,

                       Thanks for the reply. but it is not showing correctly