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. In the cell where you want to output the difference type the equals sign to begin your formula. In excel we do not have any inbuilt formula for subtraction or minus we use minus operator - to do the arithmetical subtraction in excel to subtract two values from each other we need to also use the equals to operator to make minus a formula for example value 1- value 2 is a minus formula where we subtract value 1 from value 2 note that the values should be in the same format to avoid error in formula.
This formula uses the WORKDAY function to subtract a specific number of workdays from a date.
To begin use your cursor to select an empty cell on the worksheet. If youre completely new to Excel you can learn how to create simple formulas in our completely free Basic Skills course. But you get SUM function to add numbers or range of cells. In Excel you will not find any function called SUBTRACT that will perform the subtraction operation.