Formula for WEEKNUM on fiscal year starting 9/30/19, week starts on a Monday and periods are not months

[Jbooze]

I have looking for a good way to deal with a fiscal year that is not a calendar year, the 12 periods in the fiscal year can cross over between two months and each week's start date is Monday. The formula in the screen shot changes the week start day to Monday and initially works for week number until I cross over into the next year within the fiscal year. In this example, the fiscal year started on 9/30/2019 and runs to 9/29/2020. The formulay breaks on 1/1/2020. Any assistance would be greatly appreciated.

Thanks,

Jeff

 

[Fluff]

Have a look here

Calc weeknumber based on company's financial year

Hi, Hope someone can help me out with this problem - which is a problem with two parts. Firstly, I need a formula that will calculate the week number based on my company's financial year. The financial year always starts on a Sunday, & in the current year (2007/2008), week 1 commenced on...

www.mrexcel.com

 

[Jbooze]

Have a look here

Calc weeknumber based on company's financial year

Hi, Hope someone can help me out with this problem - which is a problem with two parts. Firstly, I need a formula that will calculate the week number based on my company's financial year. The financial year always starts on a Sunday, & in the current year (2007/2008), week 1 commenced on...

www.mrexcel.com

Thanks Fluff. What in this formula assigns the start day so I can change it from Sunday to Monday? Also, our fiscal year is not a set start date. Example, this year started on Monday, 9/30/2019 and the year before, it started on Monday, 10/1/2018. =INT((E6-WEEKDAY(E6)-DATE(YEAR(E6+DATE(1,1,2)-DATE(0,9,29)-WEEKDAY(E6))-1,9,29)+8)/7)

 

[Fluff]

I'm afraid I haven't got clue