Excel 2010: Calculating the Days in-between two Dates

Hi Experts!

    Hopefully a simple question. I have a report that generates the time/date in two separate columns (See example below).  I need to calculate the days in between these two dates, excluding the time.  Possible?

Example:

Column A                         Column B
7/20/2016 5:49 AM         7/21/2016 2:00 PM

Thanks a million in advance!
itsmevicAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Wayne Taylor (webtubbs)Connect With a Mentor AstronautCommented:
Convert each date to integers and subtract B from A....

    =INT(B2)-INT(A2)

Wayne
0
 
itsmevicAuthor Commented:
Perfect! Thank you.
0
All Courses

From novice to tech pro — start learning today.