Functions Day 2

Functions Day 2 - Date and Time Functions Excel's date...

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

View Full Document Right Arrow Icon

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

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

Unformatted text preview: Date and Time Functions Excel's date conventions Today's date 12/6/2011 1900 vs. 2000 Current time 12/6/2011 10:00 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 12/7/2011 Today 12/6/2011 1 week from today 12/13/2011 2 weeks from today 12/20/2011 3 weeks from today 12/27/2011 Birthday 1/1/1990 Today 12/6/2011 Age (unrounded) 21.9274469541 Age (rounded) 21 Today DAY MONTH YEAR DATE 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 Home 11/26/2011 TBD Virginia Away...
View Full Document

This note was uploaded on 12/06/2011 for the course ACIS 2504 taught by Professor Mtgriffin during the Fall '08 term at Virginia Tech.

Page1 / 4

Functions Day 2 - Date and Time Functions Excel's date...

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