Week Number based on Day. (Based on United States Government Fiscal Year)

[CubeMonkey]

Good day my fellow nerds,

Today I need guidance on how to figure out the Week Number based on the day.

Let me breakout a list of things you will need to know:
- The Week # being displayed will be based on the United States Government Fiscal Year 2023 which is: 1st quarter: 1 October 2022 – 31 December 2022.
- The Week # Cell will need to pull from the date Cell
- The Week # will need to be able to start over automatically, for example: After Week 52 will go back to Week 1 to start over.

*See attached picture for reference.

Any help or guidance?

P.S. If you read this, please leave a Banana in the post thread to show your support. I am just a Monkey stuck a cubicle in CubeCity. Feel the pain? Feed the Monkey! (<---Copy and Paste to feed the beast!)

-CubeMonkey

 

[MDCurry]

Assuming that your date is in cell P3 try this formula:

=ROUNDUP((P3-IF(AND(MONTH(P3)<10,MONTH(P3)>=1),DATE(YEAR(P3)-1,10,1),DATE(YEAR(P3),10,1))+1)/7,0)