ETA date without weekend days

[qv11user]

Dear All,

Hope all are doing good!

I have a requirement, I have two columns in a table ID, Days.
I want create a new column ETA for each ID and logic for this Today + Days.
For example Today(18/09/2025) + Days(5) =23/09/2025, but I want exclude weekend days(sat,sun) and add two additional days instead of them.
Which means 19/09, 22/09, 23/09, 24/09, 25/09(exclude 20/09,21/09 as these are weekend days) so the ETA date is 25/09/2025.

ID   Days   ETA
1    5         25/09/2025
2    4         24/09/2025
3    7         29/09/2025
4    8         30/08/2025
5    9         01/09/2025

If anyone come across this kind of requirement, please help me.

[robert_mika · Accepted solution]

First do you first calculation to get two dates

The use networkdays(D1,D2) to remove the weekends

Then you can create flag for the days that you do not want