topic Re: How to calculate next 5 days from a payment date excluding weekends & holidays in Product Forum

How to calculate next 5 days from a payment date excluding weekends & holidays

AkashNiayakad — Mon, 17 Feb 2025 06:23:36 GMT

Hello,

I need to know how to calculate next 5 days from a payment date excluding weekends & holidays. Does anyone have any ideas to do this?

Re: How to calculate next 5 days from a payment date excluding weekends & holidays

plnarayana777 — Mon, 17 Feb 2025 08:06:46 GMT

Hi @AkashNiayakad ,

Assuming you have created a calendar with all your holidays in system tab

If your requirement is to get next working day after 5 working days of payment date then use BP internal object Calendar, action add working days

or if your requirement is to get list of working days then do the above step first and then use get working days in range action to get all the working days by providing the payment date and output from first step

Hope this helps

Regards

Re: How to calculate next 5 days from a payment date excluding weekends & holidays

AkashNiayakad — Mon, 17 Feb 2025 09:46:04 GMT

Hi @plnarayana777 ,

Thank you very much for your help. The action Add working days in the Calendar Object worked perfectly.