Home » Office » Excel 2016 Math with Dates and Times

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

• 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