Count days between two dates function

Celtic Las

New member
Joined
Dec 9, 2013
Messages
1
Reaction score
0
Points
0
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!
 

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,770
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
Hi. Forums generally do not provide assistance for homework. You might want to have a look at cell formatting, though....
 
Top