I have a SELECT statement, it is calculating the same DateDiff about 5 times. I'm using some CASE WHEN stuff and the result of DateDiff in days is how I determine what part of the case it goes with.

Finding the exact difference between two dates in Excel may not be the most used feature, but it can be a lot of fun. A classic example is working out someone’s age. It’s not as complicated as it ...