Calculate Number of Working Days Till Current Time in SQL

Let’s say we have a datetime column and want to calculate the number of working days till the current time.

At first spot it seems like an easy thing, as SQL has the DateDiff function. However, it does not exclude the weekends: