Does anyone know how to use the DateDiff function to return the number of workdays (M-F) between two dates in SQLServer. Or is there any other function you can use. Can you write your own functions to use in views? If anyone has any ideas I would appreciate your comments.

Thanks