Essential Excel 2016 by David Slager

Author:David Slager
Language: eng
Format: epub
Publisher: Apress, Berkeley, CA

2.Press the refresh key (F9). This changes the date to a serial date. See Figure 8-46.

Figure 8-46.The date displayed as a serial date

3.Press Enter to commit the entry. The serial number then reverts back to a date format. The date will then always show as the date you made the entry.

Exercise 8-3: Using Today Function with Int Function

In this exercise you will you use the TODAY function and a person’s birthdate to determine his or her age. 1.Enter the data in Figure 8-47 in a new worksheet. Name the worksheet “Age.” We want to determine the age for those whose birthdate appears in column B. Add your name and birthdate to the list.

Figure 8-47.Enter this data in a worksheet named Age

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.