2] Using the DAYS function. DAYS is a date function in Excel that calculates the difference between two given dates in days.It can recognize dates passed as ‘strings’ if they can be parsed as ...

To ensure that Excel converts your date to a number enter it like this, without quotes: "4/4/2011". Then click on cell "A2" and enter the later of the two dates in the same manner.

Excel provides two options for calculating the difference between two dates. You can use a simple subtraction operation such as "=B2-A2" to calculate the amount of days between those two calendar ...

If you need to check for the number of leap years between two dates in Excel, please read through this article. A leap year has one day more than a non-leap year, but it impacts a lot of calculations.

Since subtracting two dates also yields the number of days between, the formula =(C2-A2)/(B2-A2) would result in the same percentage. Figure B The DATEDIF function makes it easy to calculate ...

You already knew that Excel can do straight date math, but it can also take into account holidays to find the number of working days between two dates. Tech blogger Chandoo points out the ...