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.
Calculating the number of days using Excel is pretty simple. Just use a formula to subtract the later date from the earlier date. For example, if cell A1 contains 1-Jan-2004 and cell A2 contains 03-Mar-2004, you simply enter the formula =A2-A1 in cell A3 to get the number of days.At first the result may look strange.owever, calculating the number of months or years between two dates isn't so obvious. There's a Function in Excel that makes this task easy but for some reason Microsoft has hidden it away. You won't find it in the Paste Functions list (Insert, Functions).