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.
Convert date to weekday name or month name with Text function. Microsoft Excel's Text function can help you to convert date to its corresponding month name or weekday name easily. In a blank cell, please enter this formula =TEXT(A1,mmmm), in this case in cell C1. , and press the Enter key. And then drag this cell's AutoFill handle to the range as you need. And the date have been converted to month name.