Mastering Excel Date & Time Formulas

Mastering Excel Date & Time Formulas

3.0 3
by Tim Hill
     
 

Updated for Excel 2016. Calculations with dates and times are among the most common spreadsheet operations, and Excel's capabilities go far beyond routine TODAY and DATE formulas. Author Tim Hill shows you how to use worksheet functions, array formulas, AutoFill, and other Excel features to work with date and time values. If you're using an older version of Excel that… See more details below

Overview

Updated for Excel 2016. Calculations with dates and times are among the most common spreadsheet operations, and Excel's capabilities go far beyond routine TODAY and DATE formulas. Author Tim Hill shows you how to use worksheet functions, array formulas, AutoFill, and other Excel features to work with date and time values. If you're using an older version of Excel that doesn't support the latest worksheet functions, you'll find equivalent formulas that work in Excel 2003 or earlier. You can download the sample workbook to follow along with the author's examples.

- Covers all versions of Excel.
- Understand date and time serial numbers.
- Control how Excel interprets and formats dates and times.
- Resolve problems with two-digit years and negative times.
- Work around Excel's leap-year bug.
- Use the undocumented DATEDIF function.
- Generate series of dates and times.
- Convert imported text and numerical values to dates and times.
- Skip weekends and holidays in business and financial calculations.
- Find specific days of the month for holidays and paydays.
- Round times to the nearest hour, half-hour, minute, or any interval.
- Plenty of tips, tricks, and timesavers.
- Fully cross-referenced, linked, and searchable.

Contents
1. Getting Started with Dates & Times
2. Date & Time Basics
3. Date & Time Functions
4. Date Tricks
5. Time Tricks

Read More

Product Details

ISBN-13:
2940013443419
Publisher:
Questing Vole Press
Publication date:
06/18/2013
Sold by:
Barnes & Noble
Format:
NOOK Book
Sales rank:
965,071
File size:
0 MB

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >