Microsoft Office Tutorials and References
In Depth Information
Working with Date and Time
In Figure 2.1, the INDEX MATCH function returns the text result for the record corresponding to
the ISBN number. The index looks through the table array of E3:F7, matches the cell reference
ISBN number from C25, references the ISBN range, then matches the corresponding text
record from the product column.
Figure 2.1
Common LOOKUP and
REFERENCE functions
used against lists.
Working with Date and Time
TODAY
TODAY returns the current date as a serial number. There are no arguments for this function.
The TODAY function is a powerful dynamic function that allows you to see the current day ever y
time the workbook is opened. You could place the TODAY function in a cell on a report so that
you always have the correct date. Notice the example in Figure 2.2, there are no arguments for
this function.
NO Returns the current date and time in the form of a serial number with the NOW function. There
are no arguments for this function.
The NOW function calculates the time the function was entered. This could be in the form of a
year, month, day, hour, minute, or second. See the example in Figure 2.2.
EDATE
The EDATE function returns the value or serial number of the date you specified and the number
of months before or after the specified date. Use EDATE to calculate the maturity date or date due
that falls on the same day of the month as the date of issue.
The example in Figure 2.2 shows two EDATE examples with the maturity date occuring 1 and 2
months after the date of issue.
Search JabSto ::




Custom Search