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.
Answer: You can remove the time portion from a date by using the YEAR function, MONTH function, and DAY function. In this example, we have a date/time value in cell A1 and we'd like to remove the time portion from this value. The order of how you use the Year, Month, and Day functions will depend on how you're formatting your date.