Working with Data columns in Excel is many a times a necessity. There are various data tables that contains one or more date columns. There can be a need to work with the date column to do various calculations. One need can be to find the difference between 2 dates. Excel has Days360 function that helps in finding difference between two dates with assumption of 360 day year. This article explains How to use Days360 function in Excel?
John has customer spend data for his company. He is has 2 dates column “Date of Birth” and “Todays Date”. He is looking forward to find the days difference between the two dates.
Days360 Function in Excel
- Step 1: The first parameter of Days360 function is first date value. Cell J5 contains first date value,
=DAYS360(J5, )
- Step 2: The second parameter is second date value, as cell K5 contains the second date value. The second parameter will have K5
=DAYS360(J5, K5,)
- Step 3: Third Parameter tells to US method or Europe method of days. Use False for US method.
=DAYS360(J5, K5, FALSE)
- Step 3: Copy the cell L5 and paste the formulas to rest of the cells in the column. This will generate updated 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: