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 
Size524.59 Kb
File typepdf
Downloads1294
Created2017-10-09
Cover of Excel 2016 Math with Dates and Times

Download

  • Microsoft Excel 2013 for beginner

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

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

  • Advanced Word 2013

    With this PDF tutorial you will be familiar with the basic functionality of Microsoft Word 2013 and you will learn how to write document with ease....

  • Introduction to Microsoft Publisher

    Download Introduction to Microsoft Publisher in PDF, free training document about how to create a perform basic tasks and creating business and greeting card....

  • Microsoft PowerPoint 2013 step by step

    This courses is designated to beginning-level and intermediate-level computer users. It teach you some skills that can be used to make a beutiful presentation....

  • 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 course

    Download free Microsoft Office Excel 2013 file under 505 pages,step by step to learn Excel and build your skills , course tutorial training on pdf by Curtis D. Frye....

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

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

  • The Beginner’s Guide to Microsoft Excel

    This is a free Excel PDF tutorial in 11 chapters and 23 pages. This course aims to give students the basics of Microsoft Excel tips and trics. ...