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

1. ## 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. ## Re: Calculation of Week Number & Week Ending Date formula from a Year Cell

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

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

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

Originally Posted by sanram
For Week Number :
Formula:
`Please Login or Register  to view this content.`

For Week Ending Date :
Formula:
`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. ## 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....

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

Originally Posted by Glenn Kennedy
=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. ## Re: Calculation of Week Number & Week Ending Date formula from a Year Cell

You're welcome.

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

#### 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