Aon Careers Around the World. Our jobs represent all Aon divisions including Aon Benfield, Aon Hewitt and Aon Risk Solutions. For jobs in the United States, Canada, India, UK, Poland, Vietnam, and Singapore visit our global job site, jobs.aon.com. For country-specific job information, click the links below: 1  Australia.
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.
Different Ways to Subtract Dates. There are several types of computations that involve dates and subtraction in Excel. For instance, you may want to find the difference in days, months, or years between two dates in order to determine the amount of time that passed from the beginning to the end of an event.f youâre only interested in determining the number of days between two dates, the calculation is very simple. All you have to do is subtract the two cells. That is, if the first date is in cell A2 and the second one in cell B2, you can use the basic formula. = B2 â A2. as shown in the screenshot below.