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 »

Excel WEEKDAY Function

This post will guide you how to use Excel WEEKDAY function with syntax and examples in Microsoft excel. Description The Excel WEEKDAY function returns a integer value representing the day fo the week for a given Excel date and the value is range from 1 to 7. so you can use this function to get… read more »

Excel TIMEVALUE Function

This post will guide you how to use Excel TIMEVALUE function with syntax and examples in Microsoft excel. Description The Excel TIMEVALUE function returns the decimal number of the time represented by a text string. so it will convert a time represented by a text string into an Excel time value. and the returned value… read more »

Excel TIME Function

This post will guide you how to use Excel TIME function with syntax and examples in Microsoft excel. Description The Excel TIME function returns a date in serial number format for a particular time (the hour, minute and second). The serial number returned by TIME function is a value between 0 and 0.99988426. And the… read more »

Excel EDATE Function

This post will guide you how to use Excel EDATE function with syntax and examples in Microsoft excel. Description The Excel EDATE function returns the serial number that represents the date that is a specified number of months before or after a specified date. You can use the EDATE function to calculate the expiration dates… read more »

Excel Days360 Function

This post will guide you how to use Excel DAYS360 function with syntax and examples in Microsoft excel. Description The Excel DAYS360 function will calculate the number of days between two dates based on a 360-day year. The DAYS360 function is a build-in function in Microsoft Excel and it is categorized as a  DATE and TIME… read more »

Excel Days Function

This post will guide you how to use Excel DAYS function with syntax and examples in Microsoft excel. Description The Excel DAYS function returns the number of days between two dates. The DAYS function is a build-in function in Microsoft Excel and it is categorized as a DATE and TIME Function. The DAYS function is available in… read more »

Excel Day Function

This post will guide you how to use Excel DAY function with syntax and examples in Microsoft excel. Description The Excel DAY function returns a day of a date (from 1 to 31) The DAY function is a build-in function in Microsoft Excel and it is categorized as a DATE and TIME Function. The DAY function is… read more »

Excel DatedIF Function

This post will guide you how to use Excel DATEDIF function with syntax and examples in Microsoft excel. Description The Excel DATEDIF function returns the number of days, months, or years between tow dates. The DATEDIF function is a build-in function in Microsoft Excel and it is categorized as a DATE and TIME Function. The DATEDIF function… read more »

Excel Date Function

This post will guide you how to use Excel DATE function with syntax and examples in Microsoft excel. Description The Excel DATE function returns the serial number for a date. The DATE function is a build-in function in Microsoft Excel and it is categorized as a DATE and TIME Function. The DATE function is available in Excel… read more »

Sidebar