If we wish to calculate the duration or number of days between two dates we can simply subtract the two dates using the - operator and we will get the desired result. Auto fill a date series in Excel Filling a column or row with dates that increment by one day is very easy. This formula subtracts the first day of the ending month 512016 from the original end date in cell E17 562016.
The Edate function is used to calculate the maturity date and due date that falls on the months same date as the issued date.
DATEDIF A1B1d The formula takes two cells separated by commas and then uses a d to calculate the difference in days. Date function in excel is a date and time function which represents the number provided to it as arguments in a date and time code the arguments. DATEDIF A1B1d The formula takes two cells separated by commas and then uses a d to calculate the difference in days. You can also use DATE function in an Excel IF statement to compare dates like the below IF formula.