Скачать или смотреть Extract Day, Month, and Year from a Date in Excel (Quick Formula Guide)

Need to pull out the day, month, or year from a full date in Excel? This tutorial shows you how to extract each part of a date using simple formulas—perfect for organizing, filtering, or analyzing time-based data.

Excel stores dates as serial numbers, but with the right functions, you can break that down into readable parts. In this quick video, you’ll learn how to extract:
• Day using the =DAY() formula
• Month using the =MONTH() formula
• Year using the =YEAR() formula
• Bonus: How to convert full dates into text-based formats (like “March” instead of “3”) using =TEXT()

These methods work across all Excel versions (2016, 2019, 2021, Microsoft 365), and are especially useful for sorting, grouping, or summarizing large sets of date-based entries—like sales records, attendance logs, or deadlines.

Why this matters:
According to Excel usage trends in 2024, over 70% of business users rely on date formulas for data analysis and reporting. Learning to split dates into parts can help you build better dashboards, track performance by month or quarter, and clean messy datasets.

Use this when:
• You need to filter data by month or year
• You want to sort records by day of the week
• You’re preparing monthly or yearly reports from raw date entries

Watch to the end for a quick tip on custom formatting dates for better readability.