Microsoft Office Tutorials and References
In Depth Information
Working with Financial Functions
Perhaps the most commonly used date function is the TODAY function, which returns
the current date. The syntax of the TODAY function is:
The TODAY function doesn’t have any arguments. Neither does the NOW function,
which returns both the current date and the current time. The values returned by the
TODAY and NOW functions are updated automatically whenever you reopen the
workbook or enter a new calculation.
Diane wants the Budget worksheet to display the current date.
If you don’t want the
date and time to change,
you must enter the date
and time value directly in
the cell.
To display the current date:
1. In cell I1, enter the label Current Date .
2. Merge cells and , left-align the merged cell, and change the cell’s fill color to J1
Tan, Background 2 (the third color in the first row of the Theme Colors section).
3. Click cell . You’ll enter the TODAY function in this cell. K1
4. Click the Formulas tab on the Ribbon.
5. In the Function Library group, click the Date & Time button, and then click
TODAY in the date functions list. The Function Arguments dialog box opens, with
a description of the function and a reminder that there are no arguments for the
TODAY function.
6. Click the OK button. The Function Arguments dialog box closes, and the
=TODAY() function is inserted into cell L1.
7. Merge and center the range K1:L1 , and then add a border around each of the
cells in the range I1:L1.
8. Click cell to deselect the range. See Figure 3-35. K1
Figure 3-35
TODAY function displays the current date
TODAY() function displays the current date
current date (yours will be different)
Working with Financial Functions
Excel provides a wide range of fi nancial functions related to loans and interest payments.
One of these is the PMT function, which can be used to calculate a payment schedule
required to completely pay back a mortgage or loan. Figure 3-36 describes the PMT
Search JabSto ::

Custom Search