Results 1 to 3 of 3

Thread: Count days between two dates function

  1. #1

    Count days between two dates function



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

    n Excel 2013 I am trying to input a "days" function which will return the number of days between to dates. I've been trying to use the "days" function which is in the drop down menu under "DATE and TIME" ( which is in the Formulas Tab). The dialogue box promises exactly what I'm looking for- it states clearly that if I just input the start and end dates in the 2 boxes it will calculate how many days are between these and return a number. It even gives me a number just under the boxes but then below that the "formula results" = "5/22/1900 ! how can I get a simple number out of it that makes sense?

    The complete task asks for: "Enter a logical function to verify that the date the house sold occurs after the date listed. If it does, return the number of days, if not return "Check Dates". Any help with all of this, gratefully received!

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,321
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi. Forums generally do not provide assistance for homework. You might want to have a look at cell formatting, though....

  3. #3
    Did you try using the NETWORKDAYS function?

Posting Permissions

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