Thanks for the input.

I did the table solution and created the dates till 2040 and updated the table using my public holidays table.

Works a treat.

Ryan

Hi,

Thanks for your reply. It gives the same result in SSRS and VS. I even shut down VS and reloaded the project. I do know VS does not always...