This function takes two arguments: the end date and the start date. In addition, you can also use the DAYS function. Excel knows it’s a date and simply calculates the number of days between those two dates. The first formula is just a simple subtraction of the two dates, A3 – A2.