Category: Excel Function

The WEEKDAY Function returns the day of the week with the date you specified. Formula: = WEEKDAY(serial_number,) Explanations: Serial_number is required. A sequential number that represents the date you …

The TODAY Function is one of the most popular date funtions and it returns the serial number of the current date. Formula: = TODAY() Explanations: Today function may return …

The TIMEVALUE Function is to return the decimal number of the time represented by a text string. The decimal number ranges from 0 (12:00:00 am) to 0.999988426 (23:59:59 pm). …

Time Function returns the decimal number for a particular time, representing the portion of the day value that is 24 hours. The decimal number ranges from 0 (12:00:00 am) …

The SECOND function returns the seconds of a time value, and can only be an integer from 0 to 59. The function will return an error when the second …

NOW Function returns the serial number of the current date and time. Formula: = NOW() Cautions: The results of the NOW function change only when the worksheet is calculated …