Is there an equivalent function in SQL to the
'NETWORKDAYS(start_date,end_date,holidays)' function in Excel ?
NetworkDays in Excel returns the number of whole working days between
start_date and end_date. Working days exclude weekends and any dates
identified in holidays. This part isn't vital but would be nice to
have. The weekend stuff is more important.
I realise this will most likely need to be some method I write myself
(possibly based on the name of the day - Mon-Fri), but any pointers
would be appreciated if anyone has done this before.
Thanks
Ryan