Results 1 to 3 of 3

Thread: When Subtracting Dates to get number of days it comes out as "4382"

  1. #1
    Seeker Ruth2002's Avatar
    Join Date
    Aug 2019
    Posts
    9
    Articles
    0
    Excel Version
    Excel 365

    When Subtracting Dates to get number of days it comes out as "4382"



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm subtracting two dates in my document. But instead of the difference in days it comes out with a 43832 or really a date.

    Click image for larger version. 

Name:	date error.JPG 
Views:	23 
Size:	72.3 KB 
ID:	9556

    At one point it was working.

  2. #2
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    227
    Articles
    0
    Excel Version
    2007
    Check the format for Col R

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,691
    Articles
    0
    Excel Version
    365
    The first argument of MATCH is usually a single value/cell, not an entire column?

    Perhaps attach a file, trimmed down to a few rows in each table (which will still produce a value) to show the error and state the expected result(s)

Tags for this Thread

Posting Permissions

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