ExcelTips: Times and Dates
fourth edition

ExcelTips: Times and Dates includes 156 information-packed pages that will help you learn exactly how to work with dates and times in Excel. The following is the Table of Contents:

Introduction

• Need More Tips?
• A Special Note of Thanks
• Sharing this E-Book

General Date and Time Information

• How Excel Stores Dates and Times
• Changing Excel’s Starting Date
• Inserting the Date and Time
• Entering Dates in Excel
• Quickly Entering Dates and Times
• Inserting the Current Time with Seconds
• Using Early Dates
• AutoFilling with Weekdays
• Using an Input Mask
• Defeating Automatic Date Parsing
• Inserting Tomorrow’s Date
• Entering the Current Time
• Converting Text to Values

Worksheet Functions Related to Times and Dates

• Using the EOMONTH Function
• Using the WEEKNUM Function
• The EDATE Function
• Checking for Time Input
• Calculating Fractions of Years
• Calculating Months of Tenure
• Converting Julian Date Formats
• Parsing Non-Standard Date Formats
• Returning a Weight and a Date

Calculations with Times and Dates

• Rounding Time
• Calculating Averages by Date
• Calculating Future Workdays
• Calculating Week-Ending Dates
• End-of-Month Calculations
• Leap Years and Fiscal Periods
• Calculating Business Days
• Calculating Months for Billing Purposes
• Determining Business Quarters from Dates
• The Last Business Day
• Forcing Dates Forward
• Calculating the Day of the Year
• Days Left in the Year
• Counting Dates in a Range
• Weekdays in a Month
• Monthly Close-Out Dates
• Every Second Tuesday
• Converting an Unsupported Date Format
• Converting European Dates to US Dates
• Unique Military Date Format
• Converting UNIX Date/Time Stamps
• Converting Mainframe Date Formats
• Calculating Time Differences between Two Machines
• Converting Numeric Values to Times
• Converting Time Notation to Decimal Notation
• Working with Elapsed Time
• Entering Large Time Values
• Adjusting Times for Time Zones
• Elapsed Days as Years, Months and Days
• Ages in Years and Months
• Deriving Monthly Median Values
• Determining "Highest Since" or "Lowest Since"
• Alerts About Approaching Due Dates
• Calculating TV Time
• Displaying Latitude and Longitude
• Exporting Latitude and Longitude

Formatting and Sorting Times and Dates

• Using Custom Number Formats
• Understanding Date and Time Formatting Codes
• Unique Date Displays
• Working with Minutes
• Formatting for Hundredths of Seconds
• Adding Ordinal Notation to Dates
• Automatically Capitalizing Day Names
• Conditional Formatting Based on Date Proximity
• Filtering to a Date Range in the Past
• Sorting Dates by Month
• Plotting Times of Day

Times and Dates in Headers and Footers

• Header and Footer Data Codes
• Header and Footer Formatting Codes
• Multiple Line Headers and Footers
• Putting a Different Date in a Header
• Inserting the Saved Date in a Header or Footer
• Last Saved Date in a Footer
• Date Last Edited
• Specifying Date Formats in Headers

Using Times and Dates in Macros

• Recording a Data Entry Time
• Limiting Entry of Prior Dates
• Entering Dates Without Separators
• Entering or Importing Times without Colons
• Determining the Day of the Month
• Determining the Hour of the Day
• Determining Differences Between Dates
• Automatically Converting to GMT
• Displaying the "Last Modified" Date
• Noting the Workbook Creation Date
• Noting When a Workbook was Changed
• Expiration Date for Excel Programs
• Using Excel for Timing
• Hiding Columns Not within a Date Range
• Flashing Cells
• Deleting Old Data from a Worksheet
• Automatically Printing a Range
• Automatically Advancing by a Month
• Macro for Month Name
• Naming Tabs for Weeks
• Sheets for Days
• Changing Months in a Workbook
• Sheets for Months
• Referencing Worksheet Tabs
• Pulling All Fridays
• Generating Random Testing Data
• Modifying Default Year for Dates
• Is Daylight Savings Time in Effect?
• Self-Deleting Macros
• Automatically Closing a Workbook

Description	CD		Download
ExcelTips: Times and Dates	$29.99		$24.99		(1.0 MB)

You can also order ExcelTips: Times and Dates by calling our order line: 801-607-2035.