+ Reply to Thread
Results 1 to 4 of 4

Negative days between dates formula

  1. #1
    Registered User
    Join Date
    02-04-2019
    Location
    Australia
    MS-Off Ver
    MSOffice 2010
    Posts
    25

    Negative days between dates formula

    Hi Everyone just having trouble calculating negative days between days if anyone could help!


    Thankyou!

    please see attachment

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Negative days between dates formula

    Please try at D5 drag down

    =C5-$B$1

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Negative days between dates formula

    Try this formula in D5 and copy down:

    =C5-$B$1

  4. #4
    Registered User
    Join Date
    02-04-2019
    Location
    Australia
    MS-Off Ver
    MSOffice 2010
    Posts
    25

    Re: Negative days between dates formula

    Thankyou Bo and Phuocam! worked perfectly!

    I assume that =DATEDIF cant produce negative days?, ive been looking around internet for answers but haven't found anything so far.

+ 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. Replies: 10
    Last Post: 02-19-2019, 03:28 AM
  2. Negative value while calculating days between two dates
    By sarat47 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-24-2018, 03:02 AM
  3. [SOLVED] Formula needed to compare number of days between dates but exclude negative results
    By bcmilne in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-20-2017, 10:23 AM
  4. [SOLVED] Formula between dates and days not to count
    By Wskip49 in forum Excel General
    Replies: 6
    Last Post: 05-27-2015, 09:19 PM
  5. [SOLVED] eliminating the negative number when using difference between a Network Days formula
    By Alphabex in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2015, 01:15 PM
  6. Replies: 1
    Last Post: 11-01-2012, 03:41 PM
  7. Replies: 0
    Last Post: 08-23-2005, 11:52 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