Excel - Difference in days between two dates and times

Question

I was wondering how I would go about calculating the number of days between two dates and times.

For example, the difference in days between the date and time in cell C2 and the date and time in cell B2:

Cell B2 contains: 19/04/2015 04:50

Cell C2 contains: 21/04/2015 18:05

Hopefully this makes sense.

Thanks.

Answer 1

To find the days between the two you could use something like=DATEDIF(B2,C2,"d") This can be expanded to include time, months, and years.

http://www.theexceladdict.com/_t/t040303.htm

Answer 2

=datedif(B2,C2,"d")
Will give you the difference in days, B2 is oldest than C2.