week number of week commencing date

[Anonymous]

Hi there,

I need to get a unique week number for each week commencing date.

For example, for the week commencing 19/08/2019, this could be week 34, and for week commencing 26/08/2019 would be week 35.

The only issue is that for the week commencing 19/08/2019, it falls into weeks 34 and 35, when looking at Weeks in the Year. What i need is week commencing 19/08/2019 to only have a single, unique week number.

Can I please get some help with this?

Thanks

[smpa01]

@Anonymous  sorry can you elaborate . This is what I am getting.

[Anonymous]

So where you have week commencing 19/08/2019, this is week 34. But at the end of the week on the 25/08/2019, this comes up as part of week 35, even though it is within the week commencing 19/08/2019.

I need 19 - 25th to have 1 specific week number. Then the 26th onwards in that week will have its own number.  So we probably don't want to be using the Weeks within the Year function - perhaps there's a way to create my own key for week numbers for week commencing.

[smpa01]

@Anonymous  so 08/25/2019 is indeed part of wk#35. Please take a look below.

But to feed your requirement this might work

WKNumberModified=IF(WEEKDAY([Column1])=1, WEEKNUM([Column1])-1, WEEKNUM([Column1]))