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

Microsoft Excel 2016 Academic Course

Microsoft Excel 2016 Course for Beginners

Excel 2016 Shortcuts

Quick guide to Microsoft Excel 2016

Microsoft Excel 2016 Tutorial

Others related eBooks about Excel 2016 Math with Dates and Times

Microsoft Excel Tips & Tricks

These are some of my favorite tips and power features that’ll get you well on your way to ‘Excel Guru Status’ giving you not only the recognition you deserve, but also making your work more enjoyable....

Microsoft Excel 2013 for beginner

Download free Microsoft Office Excel 2013 Tutorial course material, tutorial training, PDF file on 25 pages....

Publisher 2016 tutorial pdf

Download free course about Publisher 2016, getting started with Microsoft Office Publisher 2016 by Bharathi G, PDF training document under 182 pages....

PowerPoint Presentation

This PDF tutorial introduces you to the basic features of PowerPoint which are particularly valuable in the teaching and learning environment....

Download Publisher 2016 PDF tutorial

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

Pivot Tables in Microsoft Excel

The following is a list of items you should check before creating a Pivot Table, PDF tutorial under 9 pages for beginners....

Microsoft Excel 2016 Course for Beginners

Looking for Excel 2016 tutorials? this page is a free training document of Excel 2016 courses, in pdf....

Quick guide to PowerPoint 2010

This pdf tutorial will help you understand PowerPoint 2010 features and create presentation for school or work. I will show you how to use each feature step by step so you you will learn PowerPoint 2010 easily and efficiently....

Advanced Microsoft Excel 2013

Download free Microsoft Excel 2013 advanced Tutorial , course tutorial training, a PDF file in 87 pages for beginners....

Microsoft Excel for Beginners

This is a basic computer workshop. Microsoft Excel is a spreadsheet program. We use it to create reports that need calculations and charts. In this workshop we will learn how to move around and work inside the spreadsheet....