|smartsheet formulas with dates||1.81||0.5||4942||68|
Type the =DAYS360() formula. Click inside the parentheses, and then click the earlier date's cell. Type a comma and click the later date's cell. In this example, the formula is =DAYS360(B2,B4). credit: Screenshot courtesy of Microsoft. Press Enter to have Excel calculate the difference in dates based on a 360-day year.What is the formula for due date in Excel?
Enter your due date formula in the first empty cell under the Due Date heading. Enter an equal sign, then click the cell that has the start date, enter a plus sign and finally, the number of days you want to add. Press Enter..