Actually, you add a sheet with the date as name, and you dont want to add sheets for day which are on weekends is that right ?

The Xero Solus code should work I reckon. Which line do you get the error ?