Number of weekdays between two days - StartDate question

hi
hope this helps :slight_smile:

use weekday function !!
https://blog.sqlauthority.com/2012/11/25/sql-server-find-weekend-and-weekdays-from-datetime-in-sql-server-2012/

check if weekday .. if it is SUM other wise ignore

sum ( case when weekday 1 else 0 end )

1 Like