+ Reply to Thread
Results 1 to 2 of 2

How to find the difference between 2 dates in days

  1. #1
    Forum Contributor
    Join Date
    02-10-2013
    Location
    Wolverhampton
    MS-Off Ver
    Excel 2010
    Posts
    101

    How to find the difference between 2 dates in days

    Hi, I have the following dates, 01/09/2013 and 31/08/2013, does anyone know a formula that I can use to find the difference between the two dates in the number of days.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: How to find the difference between 2 dates in days

    if your dates are in A1 and B1 then the formula

    =A1-B1
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Difference between two dates in months and days
    By pleiadeez7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2013, 01:54 PM
  2. Difference between two dates in week and days
    By newbiekinsey in forum Excel General
    Replies: 8
    Last Post: 06-06-2011, 06:02 PM
  3. difference between dates in no. of days
    By JAYLOTT in forum Excel General
    Replies: 4
    Last Post: 06-07-2007, 04:53 AM
  4. [SOLVED] difference betwwen two dates in days
    By seven in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-15-2006, 05:10 AM
  5. [SOLVED] Formula to find the working days difference between to dates?
    By Mudgeman in forum Excel General
    Replies: 2
    Last Post: 05-15-2006, 02:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1