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.
The result: 31.00 Years. To calculate the number of months from the date, enter the following formula in cell D2: =DATEDIF(A2,TODAY(),âmâ) The result: 372 Months. To calculate the number of days from the date, enter the following formula in cell E1:=DATEDIF(A1,TODAY(),âdâ) The result: 11333 Days. PS: A lot of site, avoid calculating date in Excel using DATEDIF function.