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.
=B2-B1. =month(b2)-month(b1). =year(b2)-year(b1). Placing date and time stamps into Excel is easy enough but sometimes you need to know the number of days, months, or years between two different dates.alculating the number month between two dates in Excel is useful when you are figuring out loan, mortgage, or other annuity payments. However, subtracting dates to get months in Excel is a bit trickier and rarely returns the result you expected.