BrettOlbrys1
Board Regular
- Joined
- May 1, 2018
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
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
=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