Subtraction is the easiest way to count days between two dates in Excel. You can use the arithmetic operator – (minus sign) to subtract one date from another to find the number of days between them.

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 ...