Working with Time and Date Functions in Excel - Part 2

This guide is in continuation of the Date and Time Function in Excel - Part 1. In this guide, you will learn how to work with the rest of the time and date functions in Microsoft Excel 2019. Here's the list of functions that you are going to learn:

• NETWORKDAYS
• NETWORKDAYS.INTL
• NOW
• SECOND
• TIME
• TIMEVALUE
• TODAY
• WEEKDAY
• WEEKNUM
• WORKDAY
• WORKDAY.INTL
• YEAR
• YEARFRAC

The NETWORKDAYS function gives "the total number of workdays if you provide a start date and an end date. It excludes weekends and dates that are identified as holidays while returning the output," according to Excel's documentation.

The NETWORKDAYS function has the following syntax:

The arguments old_date and new_date are required arguments in the function and represent the start date and the end date. The third argument in the function is optional. To implement the NETWORKDAYS function in Excel, consider the example given below:

The result will be updated as shown below:

The NETWORKDAYS.INTL function is very similar to the NETWORKDAYS function. This function also gives "the total number of workdays between two dates but it also has a parameter that provides you the option to select the day(s) that you want to select as the weekend which makes it different than the NETWORKDAYS function," according to Excel's documentation.

The NETWORKDAYS.INTL function has the following syntax:

The first argument, old_date, and the second argument, new_date, are the required arguments in the function whereas the third argument, opt_weekend, and the fourth argument, opt_holidays, are optional.

To implement the NETWORKDAYS.INTL function in Excel, consider the example given below:

The result will be updated as shown below:

The NOW function provides you with "the serial number for the current date and time. If the cell format is General, the output of the function is adjusted as per your regional date and time setting," according to Excel's documentation.

The NOW function has the following syntax with no arguments:

In the table given below, you can understand the working of the NOW function:

The SECOND function returns "seconds of a given time value/serial number and it ranges between 0-59," according to Excel's documentation.

The SECOND function has the following syntax:

To implement the SECOND function in Excel, consider the example given below:

The result will be updated as shown below:

The TIME function returns "the serial number for a given time and it ranges from 0 (zero) to 0.99988426, which represents the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.)," according to Excel's documentation.

The TIME function has the following syntax:

To implement the TIME function in Excel, consider the example given below:

The result will be updated as shown below:

The TIMEVALUE function returns "the serial number of the text formatted time and ranges from 0 (zero) to 0.99988426, which represents times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.)," according to Excel's documentation.

The TIMEVALUE function has the following syntax:

To implement the TIMEVALUE function in Excel, consider the example given below:

The result will be updated as shown below:

The TODAY function returns "the current date, if the cell was formatted as General before writing the function in it. If the cell is formatted as Number, it will return a serial number," according to Excel's documentation.

The TODAY function has the following syntax and has no arguments:

To implement the TODAY function in Excel, consider the example given below:

The result will be updated as shown below:

The WEEKDAY function returns "the day of the week for a given date as input. The day of the week is returned as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default," according to Excel's documentation.

The WEEKDAY function has the following syntax:

The first argument in the function is required, whereas the second argument is optional. You can learn about the response type on this Excel page.

To implement the WEEKDAY function in Excel, consider the example given below:

The result will be updated as shown below:

The WEEKNUM returns "the week number of the given date," according to Excel's documentation. The input provided to the function must be in date format else it will cause an error.

The WEEKNUM function has the following syntax:

The first argument in the function is required whereas the second argument is optional. You can learn more about the second argument on this Excel page.

To implement the WEEKNUM function in Excel, consider the example given below:

The result will be updated as shown below:

The WORKDAY function "returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Also, working days exclude all weekends and any dates which are identified as holidays," according to Excel's documentation.

The WORKDAY function has the following syntax:

The first and the second argument are required, whereas the third argument is optional. To implement the WORKDAY function in Excel, consider the example given below:

The result will be updated as shown below:

The WORKDAY.INTL function returns "the serial number of the date/date before or after a specified number of workdays along with the custom weekend parameters. The weekend parameters are used to indicate which and how many days are to be considered as weekend days. Weekend days and any other days that are specified as holidays are not considered as workdays," according to Excel's documentation.

The WORKDAY.INTL function has the following syntax:

The first and second arguments are required. The third argument and the fourth argument are optional. To implement the WORKDAY.INTL function in Excel, consider the example given below:

The result will be updated as shown below:

The YEAR function returns "the year corresponding to a date and has a range 1900-9999," according to Excel's documentation.

The YEAR function has the following syntax:

To implement the YEAR function in Excel, consider the example given below:

The result will be updated as shown below:

The YEARFRAC function returns "the year fraction that represents the number of whole days between two dates," according to Excel's documentation.

The YEARFRAC function has the following syntax:

The first and second arguments are required, whereas the third argument is optional. To implement the YEARFRAC function in Excel, consider the example given below:

The result will be updated as shown below:

With the end of this guide, you have learned all the date and time functions with simple examples in Excel 2019.