Excel Date/Time functions

Excel NOW Function

This post will guide you how to use Excel NOW function with syntax and examples in Microsoft Excel. Description The Excel NOW function returns the serial number of the current date and time. And it will be updated each time when your worksheet is changed or opened. This function do not need to add any… read more »

Excel MINUTE Function

This post will guide you how to use Excel MINUTE function with syntax and examples in Microsoft excel. Description The Excel MINUTE function returns the minutes of a time value. And the minutes is an integer number from 0 to 59. So you can use the MINUTE function to extract the minute component of a… read more »

Excel SECOND Function

This post will guide you how to use Excel SECOND function with syntax and examples in Microsoft excel. Description The Excel SECOND function returns the seconds of a time value. Or returns an integer value that represent the second component of a given excel time. And the return value is between 0-59. For example, if… read more »

Excel DATEVALUE Function

This post will guide you how to use Excel DATEVALUE function with syntax and examples in Microsoft excel. Description The Excel DATEVALUE function returns the serial number of date. And it can be used to convert a date represented as text format into a serial number that recognizes as a date format. For example, you… read more »

Excel MONTH Function

This post will guide you how to use Excel MONTH function with syntax and examples in Microsoft excel. Description The Excel MONTH function returns the month of a date represented by a serial number. And the month is an integer number from 1 to 12. And you can use the MONTH function to get a… read more »

Excel TODAY Function

This post will guide you how to use Excel TODAY function with syntax and examples in Microsoft excel. Description The Excel TODAY function returns the serial number of the current date. So you can get the current system date from the TODAY function. The serial number is the date-time code used by Excel for date… read more »

Excel YEAR Function

This post will guide you how to use Excel YEAR function with syntax and examples in Microsoft excel. Description The Excel YEAR function returns a four-digit year from a given date value, the year is returned as an integer ranging from 1900 to 9999. So you can use the YEAR function to get the year… read more »

Excel WORKDAY.INTL Function

This post will guide you how to use Excel WORKDAY.INTL function with syntax and examples in Microsoft excel. Description The Excel WORKDAY.INTL function returns the serial number of the date before or after a specified number of workdays. And this function allow you to exclude weekends and holidays as non-working days. You can use the… read more »

Excel WORKDAY Function

This post will guide you how to use Excel WORKDAY function with syntax and examples in Microsoft excel. Description The Excel WORKDAY function returns a serial number that represents a date that is the indicated number of working days before or after the starting date you specified. So you can add a specified number of… read more »

Excel WEEKNUM function

This post will guide you how to use Excel WEEKNUM function with syntax and examples in Microsoft excel. Description The Excel WEEKNUM function returns the week number of a specific date, and the returned value is ranging from 1 to 53. And this function will start to count the week number from January 1 and… read more »

Sidebar