This the modified version of the function that Steven Cameron has posted and works for any date range you enter...

--dbo.GetBusinessDays

CREATE function dbo.GetBusinessDays

(

@StartDate...

When linked to Excel SQL server will look for a table like section.

Thus by trying to read Sheet1 is not identified as a table section.

To acomplish such read you must...

simple... just use the datediff function...

update Test set workingdays = datediff(dd,startdate,enddate)

select * from Test

check help on date functions... JO