Excel 2016 Math with Dates and Times

With this tutorial, you will learn a lot of shortcuts and custom formatting options about Dates and Times in Excel 2016.

Training documents courses on 17 pages for beginners.

Table of contents

  • Dates in Excel  
  • Times in Excel 
  • Useful Date/Time Shortcuts 
  • Custom Formatting 
  • Days, Months, and Years 
  • Hours, minutes, and seconds 
  • Totaling Time 
  • Simple Date/Time Math 
  • Date Worksheet Functions 
  • DATE : Returns the sequential serial number that represents a particular date 
  • DATEVAULE : Returns the serial number of a date 
  • DAY : Returns the numeric value of the day in a valid date 
  • DAYS : returns the number of days between two dates based on a :day year 
  • EDATE : Returns serial number of the date that is a number of months away from a date 
  • EOMONTH : Returns serial number for the last day of the month 
  • MONTH: Returns the numeric value of the month in a valid date 
  • TODAY : the serial number of the current date 
  • NETWORKDAYS : returns the number of whole working days between two dates 
  • WEEKDAY : Returns the day of the week corresponding to a date 
  • WEEKNUM : Returns the day of the week corresponding to a date 
  • WORKDAY : Returns a date that is a number of working days before or after a date 
  • YEAR: Returns the numeric value of the year in a valid date 
  • YEARFRAC : Returns fraction of the year of the number of whole days between two dates 
  • Time Functions 
  • HOUR : Returns the hour of a time value 
  • MINUTE: Returns the hour of a time value 
  • NOW : the serial number of the current date and time 
  • SECOND : Returns the Seconds of a time value 
  • TIME : Returns the sequential serial number that represents a particular time 
  • TIMEVAULE : Returns the serial number of a time 
  • Datedif Function 
  • Class Exercise 
Size : 524.59 Kb
File type : pdf
Downloads: 1246
Created: 2017-10-09
Excel 2016 Math with Dates and Times

Others Excel 2016 Tutorials

Microsoft Excel 2016 Course for Beginners

Excel 2016 Shortcuts

Microsoft Excel 2016 Tutorial

Microsoft Excel 2016 Academic Course

Excel 2016 PivotTables and PivotCharts

Others related eBooks about Excel 2016 Math with Dates and Times

Excel Fundamentals

Excel Fundamentals, it's a free PDF download about Microsoft Excel intended to beginners, document in 60 pages created by St. George’s Information Services....

Introduction to Microsoft Word 2013

This support shows you in detail all the features of this new version of the popular word Microsoft Word 2013; it is for anyone wishing to discover and deepen all its features....

How to Use Microsoft® Excel®

How to Use Microsoft® Excel® The Careers in Practice Series is an textbook appropriate for a course covering Microsoft Excel at a beginner to intermediate level. It is geared toward and will be accommodating for students and instructors with little to no experience in using Microsoft Excel...

Download Publisher 2016 PDF tutorial

Download Publisher 2016 PDF tutorial by techtutor under 10 pages intended to beginners....

Excel VBA tutorial for professionals

Download free VBA tutorial course in PDF, training file in 31 chapters and 128 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

Excel Data Analysis

Download free course Excel Data Analysis, pdf file on 358 pages by Hector Guerrero....

Basic Excel Skills

This course is not intended to serve as a beginner's tutorial on Excel. Those who are new to Excel and who need a tutorial should work through abook or a CD, or take an online course....

How to Create Professional Reports and Documents in Microsoft Word

This is a free Microsoft Word PDF tutorial in 10 chapters and 39 pages. This course aims to give students the basics of Microsoft Word concepts. ...

Excel 2016 PivotTables and PivotCharts

Learn how to use PivotTable and PivotCharts in Microsoft Excel 2016, free training document for download....

Quick guide to Word 2010

A course to learn how to use the Word 2010 version, PDF training course to download for free, Microsoft Office Word 2010, training support in 4 pages...