# How many weeks left to or passed from the specific date in Excel

** 1. ** If you need to calculate a number of complete weeks ** between two dates**, do the following (for the calculation of weeks left/passed see below):

** 1.1. ** Calculate the number of days between two dates:

*= <end date> - <start date> + 1*

For example, to calculate the number of days in summer 2018:

See Calculating the Number of Days between two dates that explains why *+ 1* is added.

** 1.2. ** Divide the number of days by 7 (number of days at one week). It is necessary to return only the integer part of the division result and discard the remainder of the division result, so, use the **QUOTIENT** function:

*= QUOTIENT (numerator, denominator)*

where:

*numerator*is a dividend, a number to be divided,*denominator*is a divisor, a number to divide by.

For this example:

*= QUOTIENT (<end date> - <start date> + 1, 7)*

The 1^{st} of June 2018 is Friday, and the 31^{st} of August 2018 is Friday. So, the number of complete weeks between these dates is 13.

** 2. ** If you need to calculate a number of complete weeks ** passed from** some date, use the formula:

*= QUOTIENT (TODAY () - <start date>, 7)*

where **TODAY ()** calculates the current date.

For example, for the 1^{st} of August 2018:

** 3. ** If you need to calculate a number of complete weeks ** left to** some date, use the formula:

*= QUOTIENT (<end date> - TODAY (), 7)*

For example, for the 1^{st} of August 2018:

See also this tip in French: Combien de semaines restent ou se sont écoulées à partir de la date spécifique dans Excel.