Count the Days Between Two Dates Using a Date Formula

Written by John Gleave in Excel Training Videos Last Updated September 27, 2023

In this Excel Training video, we’re leveraging date calculations in Excel, unveiling a versatile formula that empowers you to count the number of days between user-specified start and end dates. But that’s just the beginning — we’re also taking it a step further by demonstrating how this formula can calculate the precise number of weeks, months, and years that lie between those two crucial points in time.

So, whether you’re tracking project timelines, analyzing historical data, or planning future endeavors, follow along as we show you how to master this date formula in Excel.

Resources

Enter the following into cell C2:

=B2 - A2

Enter the following into cell D2:

=INT(B2-A2) / 7

Enter the following into cell E2:

=DATEDIF(A2, B2, "m")

Enter the following into cell F2:

=DATEDIF(A2, B2, "y")

John Gleave

John Gleave has been a researcher, content writer, and senior editor at Business Tech Planet since 2022. John was formerly a data analyst and web designer with expertise in several programming languages, such as JavaScript, JQuery, PHP, CSS, SQL, and more! With a passion for writing and technology, he has now focused his skills on crafting tech guides for BTP. You can connect with John on LinkedIn.

Recent Posts