Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Find Number of Weeks Between Two Dates in Excel

Suppose you are in a situation where you have to calculate weeks from some given date range. And you need to calculate cost estimation by using those weeks, for instance. So how will you calculate those weeks? Well, you can calculate those using your calculator, or you can do it in Excel in a faster way. Guess what our topic is today? That’s right! This is how you can calculate the number of weeks between two dates in Excel.


Download Practice Workbook

You can download and practice the dataset that we have used to prepare this article.


4 Methods to Calculate the Number of Weeks Between Two Dates in Excel

Let’s assume we have a dataset, namely “Timeline for Everest Base Camp Expedition”. You can use any dataset suitable for you.

Number of Weeks Between Two Dates in Excel

Here, we have used the Microsoft Excel 365 version; you may use any other version according to your convenience.


1. Using INT Function

Firstly, you can calculate the number of weeks between two given dates by doing a simple mathematical calculation. We will subtract two given dates and then divide them by 7 to get the number of weeks. To get an integer value, we will use the INT function.

📌 Steps:

  • Initially, select the D5 cell and apply the following formula given below.
=INT((C5-B5)/7)

Here, C5 and B5 cells represent “Ending Date” and “Starting Date” respectively. In this formula, the mathematical subtraction returns the number of days first. Later, when the output is divided by 7, we get the number of weeks, but not in integers. That’s why we need to use the INT function to get the desired output.

  • Then press ENTER.

Using INT Function

  • To get the rest of the value, drag the Fill Handle tool from D5 cell to D15.

Using INT Function

  • So, the final output will be as given below.

Using INT Function

Read More: Excel Formula for Number of Days Between Two Dates


2. Applying ROUNDDOWN Function

The ROUNDOWN function returns the same output as found in the earlier method. Here, the output has been rounded down by using the ROUNDDOWN formula.

📌 Steps:

  • To begin, put the following formula in the D5
=ROUNDDOWN((C5-B5)/7,0)
  • Then press ENTER.

Applying ROUNDDOWN Function

  • Subsequently, drag the Fill Handle

Applying ROUNDDOWN Function

  • As a result, your final output will be as follows.

Applying ROUNDDOWN Function

Read More: Excel Formula to Find Date or Days for Next Month (6 Quick Ways)


Similar Readings


3. Utilizing DATEDIF Function

In this method, we will learn how to calculate the number of weeks between two dates using the DATEDIF function. The method is not hard. All you need to know is how you use the DATEDIF function to do your task.

📌 Steps:

  • As we do before, click on cell D5 and then type the following formula.
=ROUNDDOWN((DATEDIF(B5, C5, “d”) / 7), 0)
  • Press ENTER.

3. Utilizing DATEDIF Function

  • Finally, drag the Fill Handle tool from D5 cell to D15 to get the rest of the value.

3. Utilizing DATEDIF Function

  • The output will look like the below.

3. Utilizing DATEDIF Function

Read More: How to Use DateDiff Function in Excel VBA (5 Examples)


4. Employing WEEKNUM Function

By using the WEEKNUM function, you can calculate the number of weeks between two given dates. But one thing you should keep in mind is that this function will give you the correct output if two dates (from which you want to find the number of weeks) are in the same year. Sounds Confusing? Not at all!  You will understand the functionality if you look at the example that I have given below.

Suppose we have a data set that looks like this:

Employing WEEKNUM Function

Now follow the steps that are given below.

📌 Steps:

  • First, click on cell D5 and type the following formula.
=WEEKNUM(B5)-WEEKNUM(B5)

Basically, the WEEKNUM returns the week number in a year from any specific date. For this reason, we have to use the function twice for each date.

  • Press ENTER.

Employing WEEKNUM Function

  • Drag the Fill Handle tool as we have shown below.

Employing WEEKNUM Function

  • Thus, we get the values of the weeks as follows.

Employing WEEKNUM Function

Read More: How to Apply Excel Formula to Count Days from Date to Today


Calculating Number of Weekdays Between Two Dates in Excel

Now, we can calculate our weekdays between given dates employing the DATEDIF function in our Excel sheet.

📌 Steps:

  • Type the following formula in D5
=(DATEDIF(B5, C5, "d"))

In this case, we use the “d” argument as we want to find the number of days between two dates.

  • Then press ENTER.

Calculating Number of Weekdays Between Two Dates in Excel

  • Then drag the Fill Handle tool from the D5 cell to D15 to get the other value.

Calculating Number of Weekdays Between Two Dates in Excel

  • As a result, the output looks like this:

Calculating Number of Weekdays Between Two Dates in Excel

Read More: How to Calculate Number of Days Between Two Dates in Excel


Calculating Number of Months Between Two Dates in Excel

The Excel DATEDIF function also allows you to determine the number of months between two dates, like counting days.

📌 Steps:

  • Type the following formula.
=(DATEDIF(B5, C5, "m"))

In this formula, “m” gives Excel the direction to count the month as we have previously learned for counting days.

  • Then press ENTER.

Calculating Number of Months Between Two Dates in Excel

  • Drag the Fill Handle tool from the D5 cell to D15 cell to get the other value

Calculating Number of Months Between Two Dates in Excel

  • Finally, the output you get is as follows:

Calculating Number of Months Between Two Dates in Excel

Read More: How to Count Months in Excel (5 ways)


Calculating Number of Years Between Two Dates in Excel

Similarly, you can also find the number of years between two dates utilizing the DATEDIF function in Excel.

📌 Steps:

  • First, type the following formula for D5
=(DATEDIF(B5, C5, "y"))
  • Secondly, press ENTER.

Calculating Number of Months Between Two Dates in Excel

  • Next, drag the Fill Handle

Calculating Number of Months Between Two Dates in Excel

  • In turn, the output you get is as follows:

Calculating Number of Months Between Two Dates in Excel

Read More: How to Calculate Years in Excel from Today (4 Ways)


Practice Section

Additionally, we have provided a Practice section on the right side of each sheet so you can practice yourself. Please make sure to do it yourself.

Practice Section


Conclusion

We hope you have learned something new today through this tutorial. In fact, calculating the number of weeks between two dates is not hard at all, and we think all of us should learn this method to make our life a little bit easier. Nevertheless, we will be at your disposal if you have any queries. Thank you.


Related Articles

Mohammad Shah Miran

Mohammad Shah Miran

Miran is a highly motivated individual with a strong educational background in engineering. He is interested in technology and passionate about creating engaging and informative content. After graduation, Miran decided to pursue a career in content development and has been working in the field for some time. Miran is dedicated to staying current with the latest trends and technologies and is eager to continue learning and growing as a professional.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo