After installing Kutools for Excel please do as this. Its purpose is to provide the days between two dates. The formula used in here are NETWORKDAYS B2C2 and NETWORKDAYS B4C4B7B11.
Click on either the Hard Coded or Cell Reference button to view the formula that has a number of workdays that are to be subtracted from a specific date directly entered into the formula or referenced to a specific cell.
Lets assume its January 3 2016 and youd like to know what date it will be 25 days from now. Click button to select a cell that contains the start date that you want to. DATE YEAR TODAY MONTH F3DAY F3 Next we need to know if that date has already passed and you can compare that result to TODAY to find out. The Excel NETWORKDAYS Function.