Uploaded November 2026 | Updated November 2026, 9 hours ago
π΄ Save your free spot for the live Power BI + AI workshop (14 Nov, 8:30 PM IST) - courses.goodly.co.in/power-bi-ai-workshop
Why does Excel return 4 days when the dates 11 June to 15 June seem to cover 5 days?
In this video, I explain why this happens when calculating the difference between two dates in Excel and Power BI, and why adding +1 gives you the result you may actually be looking for.
The reason comes down to how Excel stores dates as numbers and what exactly gets counted when one date is subtracted from another.
If you regularly calculate date differences, durations or number of days in Excel or Power BI, this is a small detail worth understanding.
#Excel #ExcelTips #PowerBI #ExcelFormulas
===== ONLINE COURSES =====
Learn end-to-end Power BI with Goodly Insider: courses.goodly.co.in/insider.
Build your skills in Data Modeling, DAX, Power Query, Visualizations. Learn critical thinking, requirement gathering and report planning. Use AI confidently, with a clear system instead of guesswork. Learn top-notch data skills that get you promotion-ready.
===== LINKS π =====
Blog π° - goodly.co.in/blog
Corporate Training π¨βπ« - goodly.co.in/training
Need my help on a Project π»- goodly.co.in/consulting
===== CONTACT π =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Collaborations - ipsita@goodly.co.in, goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
π΄ Save your free spot for the live Power BI + AI workshop (14 Nov, 8:30 PM IST) - courses.goodly.co.in/power-bi-ai-workshop
Why does Excel return 4 days when the dates 11 June to 15 June seem to cover 5 days?
In this video, I explain why this happens when calculating the difference between two dates in Excel and Power BI, and why adding +1 gives you the result you may actually be looking for.
The reason comes down to how Excel stores dates as numbers and what exactly gets counted when one date is subtracted from another.
If you regularly calculate date differences, durations or number of days in Excel or Power BI, this is a small detail worth understanding.
#Excel #ExcelTips #PowerBI #ExcelFormulas
===== ONLINE COURSES =====
Learn end-to-end Power BI with Goodly Insider: courses.goodly.co.in/insider.
Build your skills in Data Modeling, DAX, Power Query, Visualizations. Learn critical thinking, requirement gathering and report planning. Use AI confidently, with a clear system instead of guesswork. Learn top-notch data skills that get you promotion-ready.
===== LINKS π =====
Blog π° - goodly.co.in/blog
Corporate Training π¨βπ« - goodly.co.in/training
Need my help on a Project π»- goodly.co.in/consulting
===== CONTACT π =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Collaborations - ipsita@goodly.co.in, goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!










