Скачать или смотреть Master Date Functions in Excel | Learn TODAY, NOW, DAY, MONTH, YEAR, EDATE & DATEDIF in 10minutes.

Learn how to use Excel Date Functions like TODAY, NOW, DAY, MONTH, YEAR, EDATE, and DATEDIF to calculate dates, time, and age easily.

Perfect for beginners who want to understand how to add, subtract, and format dates in Excel.
A complete practical guide to mastering Excel’s date formulas!


Hi DataFam! 👋🏽

In this video, I’ll walk you through some of the most useful Date Functions in Excel, the ones you’ll use in everyday data tasks, reports, and dashboards.

We’ll go step-by-step through how to calculate dates, add or subtract days and months, find the current date and time, and even calculate someone’s age using Excel formulas.

📘 What You’ll Learn:

How to use TODAY() and NOW() to get dynamic current dates and time

How to extract the day, month, and year from a date using DAY(), MONTH(), and YEAR()

How to add or subtract days from a given date

How to use EDATE() to move forward or backward by months (perfect for financial models or schedules)

How to calculate age in years, months, and days using DATEDIF()

Practical examples that tie everything together

💡 Why Watch This Video

If you’re learning Excel or working on data analytics, these date functions are essential for tasks like employee reports, project tracking, dashboards, and age analysis. By the end of this tutorial, you’ll know exactly which formula to use, and when.

🧠 Functions Covered

TODAY(), NOW(), DAY(), MONTH(), YEAR(), EDATE(), DATEDIF(), and simple date arithmetic (adding/subtracting days).


Leila Gharani Alex The Analyst Karani K. Akareva ExcellsFun (Mike Girvin) Excel Campus (Jon Acampora)


Follow me for more Excel and Data tutorials:

LinkedIn:   / edith-obidi-4733b219b  

Instagram: https://www.instagram.com/thedatagirl...

TikTok: https://www.tiktok.com/@mizboochee?_t...

Twitter: https://x.com/mzboochee?s=21&t=ddsIjB...