How To Calculate Date From Number Of Days In Excel Complete Guide

Enter the following formula into a blank cell to locate the result and then drag the fill handle down to the cells for getting the future date as following screenshot shown. Here write DATEDIFA1B1d A1 being the cell with start date and A2 with the end date It will output the number of days between the two dates. You can also exclude holidays by supplying a range of cells that contain holiday dates.

Enter 01032016 into column A1.

To get a future date which is 100 days later based on current date please apply the following simple formula. Lets assume its January 3 2016 and youd like to know what date it will be 25 days from now. To get the days left until deadline date please apply the below formulas. You can also exclude holidays by supplying a range of cells that contain holiday dates.