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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- excel date time
- excel 2016 large data 4 university of florida
- working with dates times in excel
- excel formulas bible
- national weather service
- converting fopr files from excel windows to libre office
- tutorial openrefine
- 068 29 dating sas and ms excel
- using date and date time in formulas
- conversion tables formulas and suggested guidelines for
Related searches
- how to calculate dates in excel spreadsheet
- working with time in tableau
- using if statements with dates in excel
- formatting dates in excel 2016
- insert dates in excel spreadsheet
- working with columns in word
- working with strings in vba
- working with data in excel
- working with tables in excel
- working with arrays in excel
- working with csv in python
- clearances for working with children in pa