Microsoft Office Tutorials and References

In Depth Information

**The Secret to Understanding Names**

The formula in Figure 3-18 uses two worksheet functions. The TODAY function returns the current

date, and the MONTH function returns the month number of its date argument. Therefore, you

can enter a formula such as the following into a cell and it will return the number of the current

month. For example, if the current month is April, the formula returns 4.

=ThisMonth

A more useful named formula would return the actual month name as text. To do so, create a

formula named
MonthName,
defined as

=TEXT(TODAY(),”mmmm”)

See Chapter 5 for more information about Excel’s TEXT function.

Now enter the following formula into a cell and it will return the current month name as text. In

the month of April, the formula returns the text
April.

=MonthName

Using cell and range references in named formulas

Figure 3-19 shows yet another example of creating a named formula, this time with a cell

reference. This formula, named
FirstChar,
returns the first character of the contents of cell A1 on

Sheet1. This formula uses the LEFT function, which returns characters from the left part of a text

string. The named formula is

=LEFT(Sheet1!$A$1,1)

Figure 3-19:
Defining a named formula that uses a cell reference.