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: 1260
Created: 2017-10-09
Excel 2016 Math with Dates and Times

Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233

Others Excel 2016 Tutorials

Quick guide to Microsoft Excel 2016

Microsoft Excel 2016 Academic Course

Microsoft Excel 2016 Course for Beginners

Excel 2016 PivotTables and PivotCharts

Excel 2016 Shortcuts

Others related eBooks about Excel 2016 Math with Dates and Times

Beginning Excel 2019

Download free course Beginning Excel 2019, pdf file on 387 pages by by Noreen Brown, Barbara Lave, Hallie Puncochar, Julie Romey, Mary Schatz, Art Schneider, Diane Shingledecker....

Essential PowerShell

This book written to provide clear and concise explanation of topics for programmers both starting to learn the PowerShell programming as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....

Microsoft PowerPoint 2007

This PDF tutorial is aimed at beginner who wants to creat their own PowerPoint presentation ,easy course with illustrative images,free training lesson under 14 pages by Dawn Rauscher....

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....

Word 2013 Keyboard Shortcuts

Free Microsoft Word 2013 Keyboard Shortcuts in PDF for download ,a free training document under 20 pages to make Word easy to use and understand....

Download Publisher 2016 PDF tutorial

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

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...

Guide PowerPoint 2013

Guide of Microsoft Powerpoint 2013 in PDF a quick references card to learn the basics of PowerPoint,a free tutorial for download and training document under 2 pages designated to begginers....

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....

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. ...