Calculate Next Business Date based on System Date

This bot can be used to retrieve the next business working day based on system date

Top Benefits

  • Easy to plug this bot within other bots

Tasks

  • Check the date and check next day is a weekend or not
  • Check if the next day is a holiday or not, else try the next day
  • Excel operations

This bot will calculate the next working day based on the current system date.
While getting the next working day, the bot will exclude weekends (i.e. Saturday and Sunday) as well as the applicable holidays of the user, provided a holiday list is available.
The checking will continue in a loop until the bot gets the next business working day.

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
91
Vendor
Automation Type
Bot
Last Updated
June 22, 2023
First Published
April 24, 2023
Platform
Automation 360
ReadMe
ReadMe
Support

See the Bot in Action

Loop to check next working day
Excel operation
Variable Assignment
PREV NEXT
Loop to check next working day
Excel operation
Variable Assignment

Setup Process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

That's it - now the Bot is ready to get going!

Requirements and Inputs

  • A holiday list is needed, in Excel format.
  • System Date