How do I use the DATEDIF function in Excel?

Veröffentlicht am: 14 Mai 2024
auf dem Kanal: Morpheus Formation | Excel, Power BI, Sheets

7,529

🚨 Test your Excel skills (with answer key) and receive exclusive resources 🎯
➜ https://www.morpheus-formation.fr/blo...

🎁 Follow our free Excel training → https://www.morpheus-formation.fr/for...

🏆 Excel training eligible for CPF funding – Up to 100% financeable, all levels, 100% personalized → https://www.morpheus-formation.fr/for...

💡 ABOUT THIS VIDEO

The DATEDIF function calculates the number of days, months, or years between two dates.

Note: DATEDIF is not listed among Excel's functions, but it exists!

Syntax: DATEDIF(Start_Date;End_Date;Unit)
⇢ Start_Date is the earliest (lowest) date.
⇢ End_Date is the latest (highest) date.

⇢ Unit is the interval between Start_Date and End_Date.

In this video, our trainer Nicolas explains the benefits of using the DATEDIF function.

🏢 WHO ARE WE?

Morpheus Formation is an organization 100% specialized in Excel and its latest features.
Have your company and your profession evolved over the past 15 years? Excel has too!
With a satisfaction rating of 9.8/10 in 2024, we have already supported more than 500 learners and 50 companies, including Pernod Ricard, Cartier, and Orange.

Our Excel training courses are suitable for both businesses and individuals, with personalized support using your own files.

🎓 OUR EXCEL TRAINING COURSES
1️⃣ Personalized training, delivered live by an expert instructor, tailored to your needs.

2️⃣ Exclusive exercise materials and the opportunity to work on your files during the sessions.

3️⃣ Ultra-flexible scheduling (weekdays, holidays, weekends, etc.).

📌 Excel training for all levels → https://www.morpheus-formation.fr/for...

💡 CHAPTERS
00:00: How do dates work in Excel?

01:14: The DATEDIF Function

🎁 OTHER FREE RESOURCES
📂 20 Excel Exercises to Progress Quickly → https://www.morpheus-formation.fr/blo...
📥 Free PDF: 25 Essential Excel Functions → https://www.morpheus-formation.fr/blo...
⌨️ 20 Excel Keyboard Shortcuts to Remember → https://www.morpheus-formation.fr/blo...

📬 FOLLOW US
🌐 Official Website → https://www.morpheus-formation.fr/
💼 LinkedIn → / morpheus-formation

Auf dieser Seite können Sie das Online-Video How do I use the DATEDIF function in Excel? mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Morpheus Formation | Excel, Power BI, Sheets 14 Mai 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 7,529 Mal angesehen und es wurde von 38 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

2,725