Hi, the reason for this is because when you enter dates into excel, it converts it from a number value that excel has stored into the date (assuming you have it formatted as a date). If you were to set the format of those dates to general, it should show you that the value is 43388 and 43389 respectively. So when you subtract them, you get 1, which is the difference in those numbers and also the difference in days between the 2.