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.
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.
As the name suggests, Today function in Excel will help you to display the current day’s date. Syntax =TODAY()
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.
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.
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)
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)
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.
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.
If you want to display the current date as well as current time then use the NOW function. Syntax=NOW()
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???