Class 17: Date & Time Copy Copy

Date and Time:

Summary: In this class, you will learn to create a valid date from the individual year, month, and day components. Excel Date and Time functions can be used to extract information from, and perform operations on, Excel Dates and Times. 

Formula:

Today’s date = today () 

Date and time = Now ()

• If you want to input formula in date: Day: =DAY(target date) , Month: =MONTH(target month), Year: =YEAR(target month)
• If you want to input the formula in Time: Hour: =HOUR(target time) , MIN: =MIN(target time), seconds: =SECOND(target time)