Lesson#16: Know about function TODAY, NOW, HOUR, MINUTE, SECOND, YEARFRAC

Lesson#16 will introduce you to some more new function TODAY, NOW, HOUR, MINUTE, SECOND, YEARFRAC.

Function TODAY returns the current date formatted as a date.

Function NOW returns the current date and time formatted as date and time.

HOUR(serial_number) returns the hour as a number from 0 (12:00 am) to 23 (11:00 pm)

MINUTE(serial_number) returns the minute as a number from 0 to 59

SECOND(serial_number) returns the second as a number from 0 to 59

Now I will talk about the function YEARFRAC. This function returns the year fraction representing the number of whole days between start_date and end_date. Syntax of the function is =YEARFRAC(start_date, end_date, [basis])


In the basis area, you will get this option as shown in the picture. I have chosen 3 for Actual/365.

Here the result is shown.

Related video tutorials: