Solved

Excel 2010:  Calculating the Days in-between two Dates

Posted on 2016-09-22
2
37 Views
Last Modified: 2016-09-22
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!
0
Comment
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
  • Learn & ask questions
2 Comments
 
LVL 47

Accepted Solution

by:
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

by:itsmevic
ID: 41811692
Perfect! Thank you.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

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.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question