Excel Time and Date Functions You Can't Miss!

Published: 28 June 2021
on channel: RBX Excel videos

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

Watch video Excel Time and Date Functions You Can't Miss! online, duration hours minute second in high quality that is uploaded to the channel RBX Excel videos 28 June 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 55 times and liked it 1 visitors.