Functions Day 2

Functions Day 2 - DateandTimeFunctions Today'sdate...

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

View Full Document Right Arrow Icon
Date and Time Functions Excel's date conventions Today's date 9/13/2011 1900 vs. 2000 Current time 9/13/2011 14:46 2 digit years from 00-29: 2000s First day of the year 2 digit years from 30-99: 1900s Days from Jan. 1 PCs vs. Macs PCs use a 1900 date convention Times > midnight 9/9/2011 1:00 Macs use a 1904 date convention Tomorrow's date 9/14/2011 Today 9/13/2011 1 week from today 9/20/2011 2 weeks from today 9/27/2011 3 weeks from today 10/4/2011 Birthday 1/1/1990 Today 9/13/2011 Age (unrounded) 21.7 Age (rounded) 21 Today DAY MONTH YEAR DATE
Background image of page 1

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

View Full DocumentRight Arrow Icon
VT Football Schedule Date Time Opponent Home/Away Day 9/3/2011 12:30 Appalachian State Home 9/10/2011 15:30 East Carolina Away 9/17/2011 16:00 Arkansas State Home 9/24/2011 15:30 Marshall Away 10/1/2011 TBD Clemson Home 10/8/2011 TBD Miami Home 10/15/2011 TBD Wake Forest Away 10/22/2011 TBD Boston College Home 10/29/2011 TBD Duke Away 11/10/2011 20:00 Georgia Tech Away 11/17/2011 20:00 North Carolina
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/11/2011 for the course ACIS 2504 at Virginia Tech.

Page1 / 4

Functions Day 2 - DateandTimeFunctions Today'sdate...

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

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