Solved

# Excel 2010:  Calculating the Days in-between two Dates

Posted on 2016-09-22
37 Views
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

0
Question by:itsmevic
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 47

Accepted Solution

Wayne Taylor (webtubbs) earned 500 total points
ID: 41811633
Convert each date to integers and subtract B from A....

=INT(B2)-INT(A2)

Wayne
0

Author Comment

ID: 41811692
Perfect! Thank you.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, tâ€¦
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
###### Suggested Courses
Course of the Month5 days, 2 hours left to enroll