+ Reply to Thread
Results 1 to 6 of 6

Calculation of Week Number & Week Ending Date formula from a Year Cell

  1. #1
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    762

    Calculation of Week Number & Week Ending Date formula from a Year Cell

    Hi Experts,

    I do have Date 01/16/2016 in Cell i2 and we are following first week of the year from first Monday to Sunday. So would like to request to you kindly do provide the "WEEK NUMBER" and "WEEK ENDING DATE" formula based on the same conditions.

    Thank you for your precious phase and valuable contribution.

    Regards,

    Neilesh

  2. #2
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: Calculation of Week Number & Week Ending Date formula from a Year Cell

    For Week Number :
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    For Week Ending Date :
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    762

    Re: Calculation of Week Number & Week Ending Date formula from a Year Cell

    Quote Originally Posted by sanram View Post
    For Week Number :
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    For Week Ending Date :
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dear Expert,

    The provided formula is giving the result as 3 but as per first week counting from monday it should be 2. Would like to request to you please do provide the requested formula.

    Regards,

    Neilesh

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,821

    Re: Calculation of Week Number & Week Ending Date formula from a Year Cell

    =WEEKNUM(A1,21)

    is what you want, as your definition of the first week of the year is"system 2", from memory....
    Glenn



  5. #5
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    762

    Re: Calculation of Week Number & Week Ending Date formula from a Year Cell

    Quote Originally Posted by Glenn Kennedy View Post
    =WEEKNUM(A1,21)

    is what you want, as your definition of the first week of the year is"system 2", from memory....
    Dear Expert,

    Exactly Sir, That is what i was looking for. Thank you once again Sir.

    Regards,

    Neilesh

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,821

    Re: Calculation of Week Number & Week Ending Date formula from a Year Cell

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Calculate Week Range from Week Number, Month and Year?
    By A108A108 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-07-2016, 03:11 PM
  2. [SOLVED] Finding number of days between dates and categorising by week ending date
    By benoj2005 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2016, 07:42 AM
  3. [SOLVED] number of days between dates by week ending date
    By benoj2005 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-23-2015, 12:19 AM
  4. [SOLVED] Get the date of saturday in a week from a week number / year
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2015, 06:56 PM
  5. Sheets for every week + start and ending date of the week
    By wimexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-30-2012, 01:48 PM
  6. formula/macro. How to convert data (weekday, week number, year) to a date?
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2011, 10:34 PM
  7. [SOLVED] Calculating a Date Based on Year, Week Number and Day of the Week
    By amy in forum Tips and Tutorials
    Replies: 1
    Last Post: 08-23-2005, 11:42 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1