Working with Dates & Times in Excel - University of Southern California
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
- formula and function in excel pdf format example sheet
- vba excel date format dd mm yyyy
- excel date and time functions investintech
- change date format in excel
- apostrophe excel date format
- excel convert date to text format
- date format excel change
- excel datevalue formula
- excel date format day of week
- microsoft excel 2019 formulas and functions
Related searches
- how to calculate dates in excel spreadsheet
- university of southern california tuition
- using if statements with dates in excel
- formatting dates in excel 2016
- insert dates in excel spreadsheet
- university of southern florida hospital
- university of southern florida admissions
- fires in southern california today
- university of irvine california address
- working with excel 2016
- working with large excel spreadsheets
- working with excel spreadsheet