Recently a client wanted help in summarising a large data list of employees. They wanted to identify the years of service in terms of 5, 10, 15 years and other milestone years based on a start date. The list they had looked like the one below (made up names and start dates). (The file with … Continue reading Identify Milestone Years in Excel