Excel Date & Time Functions

Date & Time Functions

"Thanks you everyone for your response. Today we are going to discuss Excel's Date & Time functions. These functions are really important because it is most common that you would have date & Time in your data and you want to extract some meaningful information.

 

Lets start the functions :)

• TODAY - Returns the serial number of today’s date. 

• NOW - Returns the serial number of the current date and time (time is not there when you use Today). 

• DAYS360 - Calculates the number of days between two dates, based on a 360-day year. 

• EDATE - Returns the serial number of the current date and time. 

• EOMONTH - Converts a serial number to a day of the month. 

• NETWORKDAYS- Returns the number of whole workdays between two dates. 

• WEEKNUM - Returns the week number in the year. 

• WORKDAY - Returns the serial number of the date before or after a specified number of workdays. 

• Datedif- Show you differene between 2 dates, using multiple criteria.

• This function does not show up automatically, the intelisense feature does not work for this. you need to type it exactly like this.

•  DAY- Converts a serial number to a day of the month.

• MONTH- Converts a serial number to a month.

• YEAR - Converts a serial number to a year.

• DATE - Returns the serial number of a particular date.

• HOUR- Converts a serial number to an hour.

• MINUTE - Converts a serial number to a minute.

• SECOND - Converts a serial number to a second.

• TIME- Returns the serial number of a particular time.

• DATEVALUE- Converts a date in the form of text to a serial number.

• TIMEVALUE - Converts a time in the form of text to a serial number.

Here is the sample file you can use it to practice where I have created some of the samples..

                     Download workbook

Here is the YouTube video, where I have explained everything..

Please get in touch for any query help or suggestion..
Youtube
Facebook Page
Twitter
Email: lkthecool@gmail.com