Negative result if Date 1 Date 2 - the formula will return a negative number is the start date is later than the end date. Check the Add option from the Type section. D5 - C5 The result is the difference in days between the original date and the current date.
Full feature free trial 30-day no credit card required.
Enter your due date formula in the first empty cell under the Due Date heading. Then click to select a cell that you want to calculate a future date based on. Date N days The key point is to supply the date in the format that Excel understands. After installing Kutools for Excel please do as this.