Haruto is an uncompromising, courageous, energetic and masculine man, who likes to think that he is pretty tough. But despite a certain coarseness and a triumphant air he is an extremely sensitive individual (although he tends to keep this under control), and a very charming one at that (a quality that he discreetly cultivates).
To subtract in Excel, enter the numbers in a cell using the formula =x-y, complete the same formula using the column and row headings of two different cells, or use the SUM function with negative numbers. Excel does not have a specific SUBTRACT function.
In your Excel worksheet, the formulas may look as follows: 1  To add years to a date in Excel: =DATE(YEAR(A2) + 5, MONTH(A2), DAY(A2)) The formula adds 5 years to the date in cell A2. 2  To subtract years from a date in Excel: =DATE(YEAR(A2) - 5, MONTH(A2), DAY(A2)) The formula subtracts 5 years from the date in cell A2.