Excel Time and Date Functions You Can't Miss!

Опубликовано: 28 Июнь 2021
на канале: 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

Смотрите видео Excel Time and Date Functions You Can't Miss! онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал RBX Excel videos 28 Июнь 2021. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 55 раз и оно понравилось 1 посетителям.