cancel
Showing results for 
Search instead for 
Did you mean: 

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

AkashNiayakad
Level 3

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?

1 BEST ANSWER

Helpful Answers

plnarayana777
Level 7

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

View answer in original post

2 REPLIES 2

plnarayana777
Level 7

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

AkashNiayakad
Level 3

Hi @plnarayana777 ,

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