Financial Year week number with a twist

[Glenno557]

Hi all, I use ISOWEEKNUM to calculate the week of the financial year but it needs to be tweaked which is beyond my skills. I don't know if there is a more suitable formula for this problem.
The weeks are from Monday to Sunday, and 1st July is not necessarily day 1 of week 1. For July 2024 the 1st of July is Saturday, and week 1 finishes on Sunday 2nd July, with Monday 3rd July being the first day of week 2.
As an example, for FY2023-24 I use ISOWEEKNUM-175, which works perfectly until the completion of week 52, when the week number reverts to 1 instead of 53 from 24/06/2024 onwards. I need more arguments in my formula, but so far have been unable to come up with a solution?

 

[awoohaw]

Try this:

Mr excel questions 48.xlsm
	A	B
1	Day Date	weeknumber
2	Fri 2023/06/30	0
3	Sat 2023/07/01	0
4	Sun 2023/07/02	0
5	Mon 2023/07/03	1
6	Tue 2023/07/04	1
7	Wed 2023/07/05	1
8	Thu 2023/07/06	1
9	Fri 2023/07/07	1
10	Sat 2023/07/08	1
11	Sun 2023/07/09	1
12	Mon 2023/07/10	2
13	Tue 2023/07/11	2
14	Wed 2023/07/12	2
15	Thu 2023/07/13	2
16	Fri 2023/07/14	2
17	Sat 2023/07/15	2
18	Sun 2023/07/16	2
19	Mon 2023/07/17	3
20	Tue 2023/07/18	3
21	Fri 2024/06/14	50
22	Sat 2024/06/15	50
23	Sun 2024/06/16	50
24	Mon 2024/06/17	51
25	Tue 2024/06/18	51
26	Wed 2024/06/19	51
27	Thu 2024/06/20	51
28	Fri 2024/06/21	51
29	Sat 2024/06/22	51
30	Sun 2024/06/23	51
31	Mon 2024/06/24	52
32	Tue 2024/06/25	52
33	Wed 2024/06/26	52
34	Thu 2024/06/27	52
35	Fri 2024/06/28	52
36	Sat 2024/06/29	52
37	Sun 2024/06/30	52
38	Mon 2024/07/01	53
Glenno557

Cell Formulas
Range	Formula
B2:B38	B2	=NETWORKDAYS.INTL(DATE(2023,7,1),A2,"0111111")

 

[Glenno557]

Thanks a lot for replying awoohaw but it's not quite there - I need 1st and 2nd of July to be week 1, with 3rd July the first day of week 2. 24th June 2024 to 30th June 2024 will be week 53. I've been playing with this formula but, as I don't understand the logic, I'm not getting it right.

 

[Phuoc]

Try this

Book1
	A	B
1	Day Date	Weeknumber
2	7/1/2023	1
3	7/2/2023	1
4	7/3/2023	2
5	7/4/2023	2
6	7/5/2023	2
7	7/6/2023	2
8	7/7/2023	2
9	6/23/2024	52
10	6/24/2024	53
11	6/30/2024	53
Sheet1

Cell Formulas
Range	Formula
B2:B11	B2	=NETWORKDAYS.INTL(DATE(2023,7,-6),A2,"0111111")

 

[Glenno557]

That's perfect! Thanks so much.