MENU

Fun & Interesting

Master Date Functions in Excel (HUGE time saver)

Kenji Explains 40,077 7 months ago
Video Not Working? Fix It Now

Learn Date Functions in Excel from Beginner to Pro in 10 minutes! 🚀 Take our Data Analyst Program here: https://www.careerprinciples.com/career-track/the-data-analyst-program 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/bgnk3upda2 In this tutorial, you'll learn all of the essential date functions in Excel. From how to calculate the number of working days between 2 dates, to converting project timelines from months into quarters, you'll learn all the key steps. The video is divided into 5 levels from easy to hard excel date formulas. At level 1, we'll see the EDATE and TEXT functions. In level 2, the TODAY and WEEKNUM functions. Then in level 3 the NETWORKDAYS and DATEDIFF functions. In level 4 the SEQUENCE and YEARFRAC functions, and finally in level 5 custom date formatting and calculating quarters. For every date function, we'll have a realistic scenario for you to practice! LEARN: 🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🚀 All our courses: https://www.careerprinciples.com/all-courses SOCIALS: 📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en 🤳 TikTok - https://www.tiktok.com/@career_principles 🧑‍💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ Level 1: Basic Date Functions 1:58​ - Level 2: Intermediate 2:31​ - Level 3: Experienced 6:28​ - Level 4: Advanced 8:22​ - Level 5: Expert

Comment