25 Date and Time Functions in Excel You Need to Know

Learn all 25 date and time functions in Microsoft Excel.

1. Dates and Times in Excel 0:24
2. TODAY function 3:24
3. NOW function 4:18
4. YEAR function 4:59
5. MONTH function 5:44
6. DAY function 6:20
7. HOUR function 6:55
8. MINUTE function 8:06
9. SECOND function 8:36
10. EDATE function 9:12
11. EOMONTH function 11:08
12. DATEVALUE function 12:48
13. TIMEVALUE function 14:29
14. WORKDAY function 15:19
15. WORKDAY.INTL function 18:01
16. NETWORKDAYS function 19:43
17. NETWORKDAYS.INTL function 21:43
18. DATE function 23:29
19. TIME function 25:34
20. WEEKDAY function 27:05
21. WEEKNUM function 28:36
22. ISOWEEKNUM function 30:17
23. YEARFRAC function 31:10
24. DAYS function 32:45
25. DAYS360 function 33:26
26. DATEDIF function 34:42

Check out my full courses and ebooks here:

DOWNLOAD any example workbooks here:

SUBSCRIBE & get my 3 FREE eBooks.

CONNECT with me on social:

Thanks for all your support!

[HowToExcelBlog]

Check out my full courses and ebooks here

[paulvanobberghen]

FINALLY! Someone who explains dates and time in Excel properly! Congrats!

[jimmylui]

Timestamps for copying into Description
1. Dates and Times in Excel 0:24
2. TODAY function 3:24
3. NOW function 4:18
4. YEAR function 4:59
5. MONTH function 5:44
6. DAY function 6:20
7. HOUR function 6:55
8. MINUTE function 8:06
9. SECOND function 8:36
10. EDATE function 9:12
11. EOMONTH function 11:08
12. DATEVALUE function 12:48
13. TIMEVALUE function 14:29
14. WORKDAY function 15:19
15. WORKDAY.INTL function 18:01
16. NETWORKDAYS function 19:43
17. NETWORKDAYS.INTL function 21:43
18. DATE function 23:29
19. TIME function 25:34
20. WEEKDAY function 27:05
21. WEEKNUM function 28:36
22. ISOWEEKNUM function 30:17
23. YEARFRAC function 31:10
24. DAYS function 32:45
25. DAYS360 function 33:26
26. DATEDIF function 34:42

[cambike]

Would be super useful to do a tutorial on Time to decimal Time. EG 12:30 (12 hours 30 minutes = 12.5 hours), this is such a difficult function, even harder when more than 24 hours, please do a lesson on this, loads of people need it. Excellent video as normal

[darrylmorgan]

Great Tutorial! Really Well Explained..Thank You John :)

[rohitjawale]

Could that be anymore prettier!!!
Simply awesome & professional 👌

[wayneedmondson]

Hi John.. excellent.. very complete. Worth mentioning is the option of the weekend day "mask" for the two .INTL functions. where you can specify weekend days as a "1" and non weekend days as a "0" in a sequence of 7 numbers between quotation marks. So, would be no weekend days; would be one weekend day of Monday; "0101000" would be two weekend days of Tuesday and Thursday.. and so on. This feature can be useful in certain circumstances or and situations. Thanks for the videos and good learning at your channel. Thumbs up!!

[lee-jgeq]

Clear, concise and professional tutorial - thank you:-)

[Levendo]

Thank you, this is exactly what I needed.

[Eknight]

a last I get something better than usual.... thank you man..

[johnpap]

This had to be done by proffesional, appreciated.

[paulvanobberghen]

Though it’s good practice to manually close a function with a right parentheses, you can actually type tab or return if Excel expects no other mandatory arguments. Type now( + enter, for instance. Optional arguments will use default value. Not an option in complex formula with nest functions, though.

[ariskavanessen]

What happens with Time Value when you have a text written time that could be an or pm? E.g. 11:30. As no AM or PM is given does excel automatically assume it is the 24 hour clock.
Thank you.

[excelent]

Easy trick to always get the correct last day of the month is using a combination of the EOMONTH and DATE formulas. The day should not be filled in the DATE formula. It works as follows for 29/02/2020: =EOMONTH(DATE(2020, 2, ), 1).

The trick is that not filling out the day number in the date formula, Excel interprets it as the last day of the previous month (= day zero). By then combining it with EOMONTH, you have an easy way of always getting the correct end date of the month, whether the month has 28, 29, 30 or 31 days.

[kaychapman]

I found this video because I'm trying to figure out how to compare calculated elapsed time which is a value of "28:26:20" against a set threshold of 24 hours. when using comparison operators it seems to not recognize the hard value "24" as hours. This can't be that difficult but I can't find an answer anywhere

[paulvanobberghen]

You can combine date and time as a time stamp by typing ctrl semicolon then a space and ctrl Colon. Equivalent of now() but as a number, not a formula.

[oqxmrfl]

How do I customize the WORKDAY function if my work week contains Saturdays and Sundays on Mac?

[idwtv]

Does anyone know how to create a timezone sheet in excel where i enter a time of a certain time zone and excel shows me the time in different time zones. Any tutorial would help

[sofiajorge-mercury]

Hello I need to calculate time elapsed between date and time of a task being received and completed. I need to exclude weekends and it must only calculate time within 08h00 and 17h00 = can you please assist?

[akramkbd]

How can i get one cell data update information to other cell where I can find last updated date and time automatically?