Week Numbers in Period

[Former Member]

Hi,

I need to rank week numbers partitioned by fiscal period and also get total number of weeks in a period for Date

For example:

Period-Week-WeekRank-NumWeeks
201701-01-1-4
201701-02-2-4
201701-03-3-4
201701-04-4-4
201702-05-1-3
201702-06-2-3
201702-07-3-3
201703-08-1-5
201703-09-2-5
201703-10-3-5
201703-11-4-5
201703-12-5-5

Sor of like doing Rank () over (Week ORDER BY PERIOD)