 |
|
|
| The easiest way to type a date into a worksheet is as a date. For example, if you type 10/19/1960 (be sure to type out the full year), it will be interpreted by Excel as October 19, 1960. Note: If you type October 19, it'll be interpreted as October 19 of the current year-and it might be displayed as 19-Oct. |
|
|
|
|
| Move down one cell and type =TODAY(). This pastes in the TODAY function, which returns today's date. |
|
|
|
|
| In a third cell, subtract your birthday from today's date by typing the addresses of the cells that hold this information. I've typed =A3[ms]A2 in this example because today's date is listed in cell A3, and my birthday is listed in cell A2. |
|
|
|
|
| Press Enter and you see...a date! You'll need to reformat the cell as a general value to see how many days old you are. With the new date cell selected, press Ctrl+1. This displays the Format Cells dialog box. Choose General from the Category list and then click OK. |
|
|
|
|
| The value displayed in the worksheet tells you how many days old you are, which may or may not be particularly useful. To find out how many years old you are, divide the difference between the two cells by 365. You need to use parentheses to get the proper result; in this example, I've typed (A3-A2)/365. You need to press Ctrl+1 to reformat the value as a general value instead of a date. |
|
United States
(change country or region)