lesson-excel-dates-times-1

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

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

View Full Document Right Arrow Icon
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  
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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!)
Background image of page 3

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

View Full DocumentRight Arrow Icon
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
Background image of page 4
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
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online