Saving the frequently used formula:

For example, let us add a formula for calculating the value of the
previous year: = YEAR(TODAY())-1

To define a Name that returns the result of a formula:

1. Press Ctrl+F3 for the Define Name dialog box.

2. In the Names in workbook box, type LastYear.

3. Type the formula =YEAR(TODAY())-1 in the Refers to box, and then click OK.


To enter the formula into a cell:

1. Type the = sign, and then press F3 for the Paste Name dialog box.

2. Select the Name LastYear, and then click OK.