Excel Time and Date Functions You Can't Miss!
In this video, I’ll dive deep into Excel's date and time functions. Understanding how Excel interprets dates and times as numbers is crucial for effective data manipulation. I'll show you how to use these functions to streamline your workflow and enhance your data analysis. By the end of this video, you’ll be fully equipped to handle any date and time calculations in Excel with confidence.
0:00 - Intro
0:26 - How a date works in Excel
2:56 - Date functions
5:08 - Time functions
5:33 - =DAYS - days in between two dates
6:37 - =NETWORKDAYS - calculate working days between two dates
7:41 - =NOW - calculate the actual date and time
9:07 - =WEEKDAY - calculate day of the week
10:19 - =WEEKNUM - calculate the week number of a date
Dutch translation of the functions used in this video:
=DATE - =DATUM
=DAY - =DAG
=MONTH - =MAAND
=YEAR - =JAAR
=TIME - =TIJD
=HOUR - =UUR
=MINUTE - =MINUUT
=DAYS - =DAG
=NETWORKDAYS - =NETTO.WERKDAGEN
=NOW - =NU
=WEEKDAY - =WEEKDAG
=WEEKNUM - =WEEKNUMMER
