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