On the Home tab in the Styles group click. Enter 01032016 into column A1. Another way to enter a future date based on todays date is to type TODAY 10 in the cell.
In this example the start date is in cell D17 and the end date is in E17.
The Excel NETWORKDAYS Function If youd like to calculate the difference between two dates while excluding weekends and holidays use the NETWORKDAYS function instead. Under Category click Date select. You need to specify the Start Date and the End Date in the Days function and it will give you the total number of days between the two specified dates. When you have a valid date in Excel you and just add days directly.