course bg
EduPristine>Blog>Date and Time functions in Excel

Date and Time functions in Excel

April 7, 2015

Date and Time functions in Excel are sometimes the most under rated functions in Excel even when they can be of great help. Imagine inputting dates of whole year manually or counting the difference between the two days manually, we are sure that no one has so much of free time and that is where Date and Time functions will help. So here is the list of Date and Time functions in Excel that will make your work quick.

Year, Month and Day function in Excel

When you want to know only the year of a particular date then you can use the Year function. Syntax =YEAR(date)

Similarly, you can also use the Month and Day function to know the month or day of a particular date.

Year, month and day function in excel

TODAY function in Excel

As the name suggests, Today function in Excel will help you to display the current day’s date. Syntax =TODAY()

TODAY function in Excel

DAYS360 function in Excel

When you want to find the difference between the two dates, you can use the DAYS360 function. Syntax =DAYS360(start date, end date, method).

While calculating the difference, you have two method options namely US method and the European method. If you want to calculate in US method then mention FALSE in the method and if European then mention TRUE in method.

US method (False) – If the starting date is the last day of a month, it becomes equal to the 30th day of the same month. If the ending date is the last day of a month and the starting date is earlier than the 30th day of a month, the ending date becomes equal to the 1st day of the next month; otherwise the ending date becomes equal to the 30th day of the same month.

DAYS360 function in Excel (US method)

European method (True) – Starting dates and ending dates that occur on the 31st day of a month become equal to the 30th day of the month.

DAYS360 function in Excel (European method)

NETWORKDAYS function in Excel

NETWORKDAYS function in Excel helps you to find out the number of working days between the two mentioned dates, that is, it excludes the weekends while calculating the number of days. You can also mention any other holiday or a list of holidays that you would like to exclude. Syntax =NETWORKDAYS(Start Date, End Date, Holidays)

.

NETWORKDAYS function Excel

WEEKDAY function in Excel

WEEKDAY function in Excel tells you the day of the week from the given date. This function starts counting from Sunday that is Sunday becomes 1, Monday becomes 2, Tuesday becomes 3 and so on. Syntax =WEEKDAY(Date)

WEEKDAY function in Excel

If you want to know the exact day instead of number then you can use =TEXT(A2, “dddd”) and you shall get the answer as Wednesday.

Text function in Excel

Hour, Minute and Second Function in Excel

To return the hour value of a particular time, you can use the HOUR function in Excel. Syntax=HOUR(Time)

Similarly you can use the MINUTE and SECOND function to return the minute or second value of particular time.

Hour, Minute and Second function in Excel

Now function in Excel

If you want to display the current date as well as current time then use the NOW function. Syntax=NOW()

NOW function in Excel

So that was the list of some important Date and Time functions which can actually save a lot of time. Which is your favorite function???

About Author

avatar EduPristine

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.

Comments

Interested in this topic?

Our counsellors will get in touch with you with more information about this topic.

* Mandatory Field

`````````````````````````````````````````````````` Post ID = 73911