Forum Discussion

Copper Contributor

Apr 25, 2018

Solved

Week Numbers between a Start and End Date

Hi All I dont know if anyone can help!! a concept that sounds simple in my head is just not coming into fruition when im trying to do it in Excel. I am trying to find a formula that will calc...

Formulas & Functions

week numbers

SergeiBaklan
Apr 25, 2018
Hi Susan,

If you'd like to calculate number of full weeks from Start Date that could be

=INT((<your date> - <Start date>)/7)

Jamil

Bronze Contributor

Apr 25, 2018

If you want to return the week number of a particular date then use function of WEEKNUM
A1 having the date use the formula below
=WEEKNUM(A1)

Susan Authers

Copper Contributor

Apr 25, 2018

Hi Jamil

thank your for your response, will this give me the week number which relates to the year i.e Jan to Dec?

I am looking for i.e Start Date 18/12/17 End Date 09/03/2018 but 20/02/2018 would be week 11 ?

SergeiBaklan
Diamond Contributor
Apr 25, 2018
Hi Susan,

If you'd like to calculate number of full weeks from Start Date that could be

=INT((<your date> - <Start date>)/7)
- Vaman21
  Copper Contributor
  Jul 18, 2019
  HiSergeiBaklan
  
  I've same problem as Susan mentioned, Let's take July month and the Employee started working on Jul1 (monday) and his ending date is 6(saturday) i would get 1 as output. If start date is Jul1 (monday) and end date is July 10 (wednesday) then i should get output as 2.
  Another question: irrespective of start date(i.e, july 1 - July 6) if end date falls before tue (i.e, july 9) i should get output as 1 and so on for the following days.
  
  appreciate your help in finding the solution, thanks in advance.
  
  Vaman21
  SergeiBaklan wrote:
  Hi Susan,
  
  If you'd like to calculate number of full weeks from Start Date that could be
  =INT((<your date> - <Start date>)/7)