Learn Microsoft Excel Online Free
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
