Counting Formula Needed

[BrettOlbrys1]

Hello again. I'm back for another question on this same topic. I want to assign the number "1" to the CURRENT WEEK and it needs to be a WHOLE number, not a number with decimals because I am looking for an exact match to "1". The problem I have run into is that I have a range of weekly dates starting from 1/4/21 through 1/2/23 (each week range is 7 days greater than the previous week) and it is assigning "1" to the week of 2/1/21, not 1/31/22. The formula I have is:

=IFERROR(CHOOSE((WEEKNUM(CY5,2)-WEEKNUM(TODAY(),2)+2),0,1,2),"")

Row 5 contains the range of dates.

I tried another formula, but it gives me decimals across the assigned numbers, but I need whole numbers to do a match: =(CY5-TODAY())/7+1

What formula do I need that will assign a "1" to the current week where the "1" or whatever number (-1, 0, 1, 2, 3, etc.) will be WHOLE numbers?

Thanks

Brett

 

[StephenCrump]

It's not clear what you mean by "current week", as your two formulae aren't consistent.

But perhaps this, where TODAY() is Thurs 3 Feb?

	A	B
1	Date	Week #
2	Mon 24 Jan 2022	-1
3	Tue 25 Jan 2022	-1
4	Wed 26 Jan 2022	-1
5	Thu 27 Jan 2022	0
6	Fri 28 Jan 2022	0
7	Sat 29 Jan 2022	0
8	Sun 30 Jan 2022	0
9	Mon 31 Jan 2022	0
10	Tue 1 Feb 2022	0
11	Wed 2 Feb 2022	0
12	Thu 3 Feb 2022	1
13	Fri 4 Feb 2022	1
14	Sat 5 Feb 2022	1
15	Sun 6 Feb 2022	1
16	Mon 7 Feb 2022	1
17	Tue 8 Feb 2022	1
18	Wed 9 Feb 2022	1
19	Thu 10 Feb 2022	2
20	Fri 11 Feb 2022	2
21	Sat 12 Feb 2022	2
22	Sun 13 Feb 2022	2
23	Mon 14 Feb 2022	2
24	Tue 15 Feb 2022	2
25	Wed 16 Feb 2022	2
26	Thu 17 Feb 2022	3
Sheet1

Cell Formulas
Range	Formula
B2:B26	B2	=1+INT((A2-TODAY())/7)
A3:A26	A3	=1+A2