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

  • Excel
  • 2016
When you plan a trip, project, etc. you can need to calculate a number of days or weeks between start and end dates, or how many days or weeks left/passed. This tip is about easy and fast way of complete weeks calculation.

    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:

Number of days in summer 2018 in Excel 2016

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)

Example of the formula QUOTIENT in Excel 2016

The 1st of June 2018 is Friday and the 31st 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 1st of August 2018:

Number of complete weeks passed from some date in Excel 2016

    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 1st of August 2018:

Number of complete weeks left to some date in Excel 2016

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.