Adding the Date in Excel
It is normal to add the date to a spreadsheet. Built into Excel 2003 are a number of DATE functions that can be used to do this. In this tutorial we will use the TODAY function.
- Click on cell C4.
- Type = TODAY ( )
- Press the ENTER key on the keyboard.
- The current date should appear in cell C4
Adding a Named Range
A named range is used to simplify entering cell references into a formula.
In addition, when the formula is copied, the cell reference doesn't change
- Select cell C6 in the
- Click on the
- Type "rate" (no quotes) in the Name Box.
- Cell C6 now has the name of "rate". We will use the name to simplify creating formulas in the next step.