Extract Day, Month, and Year from a Date in Excel

November 19, 2024

In partnership with

Today, we’ll show you how to extract the day, month, and year from a date in Excel—an essential skill for organizing and analyzing date-based data. If this is already in your Excel toolbox, feel free to skip today’s edition.

Without further ado, let’s dive in and learn how to simplify date manipulation in Excel, saving you time and effort!

The process is as follows,

1. Open Excel and Select all the Dates

Writer RAG tool: build production-ready RAG apps in minutes

RAG in just a few lines of code? We’ve launched a predefined RAG tool on our developer platform, making it easy to bring your data into a Knowledge Graph and interact with it with AI. With a single API call, writer LLMs will intelligently call the RAG tool to chat with your data.

Integrated into Writer’s full-stack platform, it eliminates the need for complex vendor RAG setups, making it quick to build scalable, highly accurate AI workflows just by passing a graph ID of your data as a parameter to your RAG tool.

2. Drag all the Dates to the right to AutoFill.

3. Select all the Dates in “Day” Cloumn.

Tired of your inbox being overwhelmed by newsletters? With Meco, your favorite reads are neatly organized in a clean, distraction-free space, making it easy to stay on top of the content you love.

4. Right Click the Mouse, and Go to “Format Cells”

5. Go to Custom and type “ddd”

6. Select all the “Month” Cells and follow the same procedure. This time in Custom Field Type “mmm”

7. Select all the “Year” Cells and follow the same procedure. This time in Custom Field Type “yyyy”

We are done. All the Day, Month and Year has been Extracted.

That’s how you can extract the day, month, and year from a date in Excel, making it easier to organize and analyze your data. Whether you’re sorting through schedules, tracking timelines, or creating custom reports, breaking down dates into their components can significantly improve your data management.

We Value Your Feedback

Was this featured story helpful? Rate it, and let us know how we can improve.

How would you evaluate our today's newsletter?

We read your emails, comments, and poll replies regularly. Your feedbacks help us to improve and deliver the best possible newsletter.

Login or Subscribe to participate in polls.

Stay tuned for more Excel tips and tricks in our future issues. If you have any questions or need further assistance, feel free to reply to this email. Happy Extracting!!!