Click the Formulas tab at the top of the window. Of Calculation Options in Excel. Then click to select a cell that you want to calculate a future date based on.
This tutorial will show you how to make your formulas calculate automatically in Microsoft ExcelThe default setting is for formulas to automatically calculat.
1Select a cell where you want to locate the calculated result and then click Kutools Formula Helper Date Time helper see screenshot. Select Manual from the Calculation options. Take the current balance C2 minus the expense A3 just like you would if you were subtracting these values on paper. Under the Calculation group click on Calculation Options and select any of the available options.