Practicing social distancing and living in a one bedroom apartment with your husband, while both of you try and work and spend twenty-four hours a day together is an interesting experience, to be sure.
Cody and I wanted to take a weekend and build a project together as our fun version of doing a puzzle together. In the regulatory affairs world, and even in the greater public service, a lot of time is expressed in terms of business days. “We will respond to the client in five to eight business days” and “The Minister’s office needs a minimum of five business days to review and approve dockets,” for example.
What exactly is a business day? Our working definition was “Any day that is a regular working day (Monday to Friday) excluding federal public holidays.
Over the past years I have spent many hours with my finger on a calendar directly counting business days. I’ve always thought there was a better way. That’s when I started using an Excel spreadsheet. Even then, that didn’t help my coworkers and wasn’t exactly what I wanted.
An so, the Business Days Calculator was born. It does the following three calculations:
- Given a start date and end date, calculate how many business days are between them;
- given a start date and a number of business days, calculate the end date; and
- given an end date and a number of business days, calculate the start date.