Leading the way in Microsoft Office Development

Assigning meaningful named to your columns in a list can be very useful when your list includes calculated columns.

Imagine the following list where you wanted to include another column containing the number of years each employee had worked for the company.

The Joining Date column could be used to calculate a Years Service column.

SS

Lets add another column and lets add the formula that will calculate the Years Service

SS

The Years Service can be calculated by finding the number of days between todays date and the joining date.

This number can then be divided by the number of days in a year, taking account of leap years.

=INT((TODAY()-D2)/365.25)

Using named ranges this formula could be changed to:

=INT((TODAY()-Joining_Date)/365.25)

Select the table

Select (Insert > Name > Create)

top row