Pick the last 5 days date. excluding weekends and public holidays

[srikanth1993]

Hi can someone help to get the last 5 days date but we have to exclude weekends and public holidays.i am able to do for weekends but not for public holidays.when publick holiday is coming in the middle of the week bot is selecting which is already processed date.can someone help me in this?

 

[sahil_raina_91]

Hi can someone help to get the last 5 days date but we have to exclude weekends and public holidays.i am able to do for weekends but not for public holidays.when publick holiday is coming in the middle of the week bot is selecting which is already processed date.can someone help me in this?

First, create a new calendar with all the holidays listed.
Use Internal VBO : Calendar and Action : Get Working Days in Range

 

[srikanth1993]

Thanks for reply. Even I have done the same