Working with dates column is need of the hour being a Data Scientist or anyone working with Dataframes. Date column requires different functions to process. Various requirement like finding days difference, extraction of year from date and many other. Everything in itself is a task to do with dates column. Finding difference in Days is very easy to do in Excel. In this article we will learn How to use Days function in Excel.
Emma has customer data for her company. She is looking forward to find difference between date of birth and todays date. In this example, Days difference column will be created with the help of two columns Date of Birth and Today’s date.
Compare two text in Excel with Exact function
- Step 1: The first parameter of DAYS function is end date, here the End date is todays date. So the End date value will contain cell K5.
=DAYS(K5, )
- Step 2: The second parameter is the start date. Here the start date is Date of birth, so the second value will contain cell J5.
=DAYS(K5, J5)
Step 3: Copy the cell L5 and paste the formulas to rest of the cells in the column. This will generate updated Check Days Difference column for whole table.
To get top certifications in Microsoft Excel and build your resume visit here. Also, you can read books listed here to build strong knowledge around Microsoft Excel.
Please visit our video tutorial to go through the example as well:
Share your feedbacks if you like the article. Like and share for more such content.
📬 Stay Ahead in Data Science & AI – Subscribe to Newsletter!
- 🎯 Interview Series: Curated questions and answers for freshers and experienced candidates.
- 📊 Data Science for All: Simplified articles on key concepts, accessible to all levels.
- 🤖 Generative AI for All: Easy explanations on Generative AI trends transforming industries.
💡 Why Subscribe? Gain expert insights, stay ahead of trends, and prepare with confidence for your next interview.
👉 Subscribe here:
Things i have seen in terms of computer memory is the fact that there are specs such as SDRAM, DDR etc, that must fit the requirements of the motherboard. If the pc’s motherboard is kind of current while there are no operating system issues, updating the memory literally takes under one hour. It’s among the list of easiest computer upgrade methods one can visualize. Thanks for giving your ideas.
It抯 hard to find knowledgeable individuals on this matter, however you sound like you understand what you抮e talking about! Thanks