Forum Discussion

Susan Authers's avatar
Susan Authers
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's avatar
    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)

Resources