You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How to calculate the working days of two different dates?
- Thread starter Naresh
- Start date
Hi Naresh,
You can make use of the Excel's in built NETWORKDAYS function for this exact same purpose.
Refer below link
https://exceljet.net/formula/get-workdays-between-dates
Here you can also specify the list of holidays in the sheet which makes it easy to use.
You just need to insert the start and end date and read the resulting days.
Refer Post #3 in below link on how to make use of a similar functionality using Blue Prism.
http://rpaforum.net/threads/add-7-days-to-a-date.1497/post-4610
If you do not want to keep an excel at a location then you can also dynamically generate the Excel on the fly. But this will require everytime inserting all the holidays and the formulas to calculate the workdays.
Post back if you are having any difficulties in implementing this.
If you do not want to go by the readymade Excel function then you will have to write a customised code stage that achieves this functionality.
You can make use of the Excel's in built NETWORKDAYS function for this exact same purpose.
Refer below link
https://exceljet.net/formula/get-workdays-between-dates
Here you can also specify the list of holidays in the sheet which makes it easy to use.
You just need to insert the start and end date and read the resulting days.
Refer Post #3 in below link on how to make use of a similar functionality using Blue Prism.
http://rpaforum.net/threads/add-7-days-to-a-date.1497/post-4610
If you do not want to keep an excel at a location then you can also dynamically generate the Excel on the fly. But this will require everytime inserting all the holidays and the formulas to calculate the workdays.
Post back if you are having any difficulties in implementing this.
If you do not want to go by the readymade Excel function then you will have to write a customised code stage that achieves this functionality.
Hi Naresh,
See if you are able to make use of the existing action 'Get Working Days in Range' of the Calendar VBO to achieve this.
For this you need to create a new Calendar in the System Manager and also add the desired holidays.
View attachment 1530871519209.png
See if you are able to make use of the existing action 'Get Working Days in Range' of the Calendar VBO to achieve this.
For this you need to create a new Calendar in the System Manager and also add the desired holidays.
View attachment 1530871519209.png
Hi Naresh,
Internal: The datatype 'text' Cannot be converted into a date.
From the error message it looks like you may be storing First Date and Last Date as Text data items but passing them as dates to the VBO action when it is expecting a date. Do check if that is the case.
Internal: The datatype 'text' Cannot be converted into a date.
From the error message it looks like you may be storing First Date and Last Date as Text data items but passing them as dates to the VBO action when it is expecting a date. Do check if that is the case.
The working days were correctly returned when I tried this action.
Are you making sure you are using 'Date' type data item and selecting the First Date and Last Date from the Calendar control.
The first parameter is the name of the Calendar in the System tab.
Action properties:
View attachment 1531368292128.png
Data Item properties:
View attachment 1531368129744.png
Are you making sure you are using 'Date' type data item and selecting the First Date and Last Date from the Calendar control.
The first parameter is the name of the Calendar in the System tab.
Action properties:
View attachment 1531368292128.png
Data Item properties:
View attachment 1531368129744.png