Solved

Excel 2010:  Calculating the Days in-between two Dates

Posted on 2016-09-22
2
28 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
2 Comments
 
LVL 47

Accepted Solution

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

    =INT(B2)-INT(A2)

Wayne
0
 

Author Comment

by:itsmevic
Comment Utility
Perfect! Thank you.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
EXCEL 2010 7 38
Filter and delete 6 14
clear from current cell down not up 2 9
Importing csv to excel - text formating 14 20
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
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…

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now