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

- Excel
- 2016

** 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 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 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: