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.
If you need to extract the month from a date, you can use the MONTH function. In the generic form of the formula above, the date must be in a form that Excel recognizes as a valid date. Here's how the formula works: The MONTH function takes just one argument, the date from which you want to extract the month. In the example, the formula is: =MONTH(B4)