The DAYS function was introduced in MS Excel 2013. Excel IF function combining with TODAY function. Formula DAYS end_date start_date The function requires two arguments.
Select the cell in which you want to insert the formula.
Use the DATEDIF function when you want to calculate the difference between two dates. This Excel date formula will calculate the number of days between two dates. Now first calculating the difference between two dates in excel so apply the B2 A2 formula. If the Start_date is greater than the End_date the result will be NUM.