Home More tutorials

Adding business days to a date using SQL

Recently I had a task that seemed very simple at first. I had a table with billing start dates and number of business days to bill. The task was to calculate the end date for each row. Basically to calculate the start date + number of business days without having to worry about holidays.

I was surprised that there is no built-in solution for this seemingly common problem. Here is my own take on the problem.

The logic is quite simple:

for each 5 working days add an entire calendar week to the starting date
after adding the whole weeks add the remaining days (for example adding 8 days means adding 1 week and 3 days)
if the resulting date is a Saturday then add 2 more days
if the resulting date is a Saturday then add 1 more day

And here is the resulting code:The bellow table lists a few test cases: SQL dates example

SQL dates example

Your feedback is welcome! Please let me know if you think there is something important that should be included in this post or if you find anything wrong!

Comments available on dev.to

Posts and tutorials

Upload docker image to AWS ECR

How to upload a Docker image to ECR using AWS CLI

A quick tutorial on how to upload a Docker image to AWS ECR using AWS CLI. The tutorial also walks you through setting up an IAM user with the necessary permissions to upload to ECR from the CLI.

DevOps AWS ECR Docker

Terraform local file

Simple way to play around with terraform locally without any cloud account

An easy way to start playing around with terraform locally without using any cloud account or any complicated local kubernetes setup.

DevOps Terraform

Encryption at rest

Encryption at rest using EF

Encryption at rest can come in handy when we have some sensitive data that we need to store in our database and we don't want to store it in plain text for everyone to see. In my case I needed to store some API keys in the database...

Entity Framework Security C# .NET

SSL

SSL Certificates - an easy to understand guide

As with any technology, I think it's very important that first we understand the problem that this technology is trying to solve. Let's try to understand the problem through an example...

DevOps Security

Portfolio architecture

Architecture of my portfolio website

Initially I just created a simple static HTML and CSS page with some images to serve as my portfolio page - no frameworks, (almost) no javascript - why over complicate it? After some time I decided that I would also write a few blog posts and tutorials...

11ty Amazon S3 Github Actions CloudFront

SQL add days

Adding business days to a date using SQL

Recently I had a task that seemed very simple at first. I had a table with billing start dates and number of business days to bill. The task was to calculate the end date for each row. Basically to calculate the start date + number of business days...

SQL MS SQL Server