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.