The DATEDIF function calculates the period or the difference between two dates in days months and years. To calculate the number of days since date ie. With the target date in B3 and the number of days in B4 the formula is as simple as adding up two cells.
The formula in cell A6 uses Excels DATE function to ensure that the date 10152015 is entered and stored as a date value.
In another cell use the DATEDIF formula with the ym parameter. Excel accepts most formats you type for the date. Between a future date and today. Follow the steps below to perform this procedure on your own.