TCM1000262 - How to use SEES to calculate a customer鈥檚 age at the effective date of claim

Version 1.0

Changes to previous version - new guidance.

Step 1

Access Microsoft Excel

  • select 鈥楽EES鈥� on the toolbar
  • select 鈥極ther calculators + forms + NPPS鈥� from the options available
  • select 鈥楧ates Calculator鈥� from the options available
  • select 鈥楢ge鈥� on the toolbar
  • enter the date of birth in the 鈥楨nter the birthday鈥� field
  • enter the date of claim in the 鈥楨nter the date for which age calculation required鈥� field
  • the age is shown in the 鈥楢ge at 鈥�./鈥�./鈥�.鈥� field.

Note: Entries must be in the order - date-month-year.

Note: Entries for date, month and year must be separated by either 鈥�-鈥� or 鈥�/鈥� - for example, 25/08/1985 or 25-08-1985.

Note: For the year, enter either the full year including century or just the decade and the year - for example, 25/08/1985 or 25/08/85.

Note: If the 鈥楢ge at 鈥�/鈥�./鈥︹�� field doesn鈥檛 display, then re-enter all the dates making sure the entries have been correctly entered.