Need help creating "Week of Quarter"

[malguera]

Hi Team,

Need some help here.

The default WEEKNUM function provides week number from the start of the year and runs 1 to 53 or 54.

If I need to show week number within the quarter, running 1 to 13 or 14 within each qtr, how should I do so?

I.e.

Thanks,

[Greg_Deckler · Accepted solution]

Try this, create 2 columns like this:

WeekNum = WEEKNUM([Date])

WeekOfQuarter = ROUNDUP(MOD([WeekNum],MAX([WeekNum])/4),0)

[Anonymous]

@Greg_Deckler  I have try your method but the number doesn't look correct. Sharing the screenshot 

[imaddrell]

I realise this is an old thread, but why does the calculation give me a week 0 for the 1st week of the quarter. Is there any way to rectify this. Great answer by the way.

[malguera]

It seems is working! Thank you! (I can't believe it was this simple haha)