i got one example, but it is useful only for calculating the number of working days.

url is: http://weblogs.sqlteam.com/brettk/archive/2005/05/12/5139.aspx

If anyone knows my query plz respond me.

Its very urgent.