25 Date and Time Functions in Excel You Need to Know
How To Excel How To Excel
63.8K subscribers
134,930 views
0

 Published On Jun 7, 2020

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:
👉 https://www.howtoexcel.org/courses/

DOWNLOAD any example workbooks here:
đź“– https://www.howtoexcel.org/downloads/

SUBSCRIBE & get my 3 FREE eBooks.
📧 https://www.howtoexcel.org/newsletter/

CONNECT with me on social:
Facebook:   / howtoexcelblog  
Twitter:   / howtoexcelblog  
LinkedIn:   / john-macdougall  

Thanks for all your support!

show more

Share/Embed