Working with Dates & Times in Excel

Working with Dates & Times in Excel

Presented by Wayne Wilmeth

Working With Dates

(Workshop Designed for Excel for Windows Default 1900 Date Schema)

Why Use Dates & Times in Excel?

You can do Math with them:

=B2-B1

You can manipulate them with functions: =DATE(YEAR(B1),MONTH(B1)+2,0)

How you type in dates and times in Excel determines whether they are recognized as dates & times or not.

Date Exercise 1

Correctly Typing in Dates

Next: Format as "Comma" Now format the dates you typed as "comma" format. Note you get large numbers.

How Excel Stores Dates

Dates are Stored as Numbers

1/1/1900 1

5/8/1930 11,086

2/4/1968 24,872

1/1/2000 36,526

12/21/2012 41,264

Dates Typed in Cells using the Formats Below are Recognized by Excel as Dates

12-15-2010

12/15/2010

December 15, 2010

Dec 15, 2010

15-December-2010

12-15-10

12/15/10

December 15, 10

Dec 15, 10

15-Dec-2010

Note: If Typing just Two Digits (instead of 4) for the Year there is a Breakpoint at 30

Typing 1/1/29 Typing 1/1/30

is seen as 1/1/2029 is seen as 1/1/1930

< 30 is seen as the current century >= 30 is seen as previous century

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download