Add 90 business days excluding weekends irrespective of holidays

Asked Mar 23 '23 at 12:14

Active Mar 23 '23 at 12:23

Viewed 16 times

We have incidents in a table with created date and I need to add 90 business days excluding Saturday and Sunday as a separate column.

We are using Azure sql database

Eg for incident 10000575 the created date is 31-01-2023

I need a value in working days column with addition of 90 business days to created date

I am new to it,so if any could help me with query it would be helpful

edited Mar 23 '23 at 12:23

asked Mar 23 '23 at 12:14

Jyoshna

Does this answer your question? [SQL Server function to add working days to a date](https://stackoverflow.com/questions/12862436/sql-server-function-to-add-working-days-to-a-date). OR [MYSQL Add working days to date](https://stackoverflow.com/questions/38522170/mysql-add-working-days-to-date) – Luuk Mar 23 '23 at 12:18

0 Answers0