Copy of DatePractice_sp10

Copy of DatePractice_sp10 - 2009.02.05 2009.03.07...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Purpose: Creator: Marilyn Griffin Notes: This practice file accompanies class notes for Chapter 3, Part 1. To practice manipulating dates in Excel, and to utilize DATE/TIME, TEXT, and other categories of Excel functions.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Enter today's date Enter your birth date Enter a formual that calcualtes your age Calculate age that is static Calculate age that is always current
Background image of page 2
Excel Date Format 2009.01.03
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2009.02.05 2009.03.07 2009.04.09 2009.05.11 2009.06.13 2009.07.15 2009.08.17 2009.09.19 2009.10.21 2009.11.23 Custom Date Format Custom Date Text (Short Month) Enter a formula that prints the following note in a cell: Today's date i Enter a formula that prints the following note in a cell: The time is (cu Custom Date Text (Long Month) is (today's date) urrent time)...
View Full Document

Page1 / 4

Copy of DatePractice_sp10 - 2009.02.05 2009.03.07...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online