lesson-excel-dates-times-1

# lesson-excel-dates-times-1 - CSCE120 Spring 2008 Excel...

This preview shows pages 1–6. Sign up to view the full content.

CSCE120 – Spring 2008 Excel Dates and Times Quiz #2 --  TODAY Lab #2 due date extended to Tuesday, March 18 th NO CLASS on Thursday, March 13th

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

View Full Document
Learning Objectives Explore how Excel works with Dates and Times To do this, we will investigate - How Excel stores dates and performs date calculations Common Problems with dates in Excel  Using basic date functions  How Excel stores times and performs time calculations Using basic time functions
How Old Are  You? Using Excel or a calculator, determine how many  days  old you are (approximately) how many  months  old you are How many days old will you be in five years? How many days until Spring Break?  (or St. Patrick’s Day!)

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

View Full Document
Dates in Excel Dates are stored as numbers (a serial number) 1 = January 1, 1900 (January 1, 1904 for Macs) 2 = January 2, 1900 To check this, try: =datevalue(“02/28/08”) =datevalue(text(today(), “mm/dd/yy”)) This allows us to perform “date arithmetic” =today() + 1 =“03/17/08” - today() =(today() – “ your-birthday” )/365 =datedif( today(), “03/24/08”, “d”) =datedif( today(), “05/31/08”, “m”) =datedif( “ your-birthdate” , today(), “y”) Date closest to 01/01/1900 Date furthest away from 01/01/1900 =datedif( start-date , end-date , “ code ) “d” for days “m” for months “y” for years
Celeb Birthdays Using the Internet, find the birthdates of three of your favorite  celebrities. Download celeb.xls from Sakai: Resources: Download - Click on the “Celeb Birthdays” worksheet tab Use the Today() function to display today’s date  Enter your name and birthdate Using date calculations and/or functions: determine how old you are  (in days and in years) Enter the three celeb names and birthdates

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 04/07/2008 for the course CSCE 120 taught by Professor Folsom during the Spring '08 term at Pacific Lutheran.

### Page1 / 17

lesson-excel-dates-times-1 - CSCE120 Spring 2008 Excel...

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

View Full Document
Ask a homework question - tutors are online