• What are you going to do when there's a holiday on a business day? Just looking to create the equivalent in an SSRS expression isn't going to solve that problem. I, for one, would never use an expression to do this, as it makes much more sense to include the necessary data in your Dataset, based on having created a holiday table and the necessary code to support taking that into account. FYI, if for whatever reason, the holidays just don't matter, then it's not that difficult to navigate through the possible date & time functions available when you're in an expression editor, and find the DATEDIFF and WEEKDAY functionality there. The IIf or Switch functions can help you with setting up the equivalent for your CASE statement. Give that a try, and if you get stuck, post what you tried and I can help from there.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)