Forum Discussion
Count Weeks in Sequential Year
I have been fighting with a formula for way too long and I hope you can help. Our “gas-week” starts on a Friday and goes through Thursday. I want to assign a week number to each date. Seems easy ...
It still gets confused in the second week of 2021. Expanded sample attached
Date Day of Week Week Num 1/1/2021 Fri 1 1/2/2021 Sat 1 1/3/2021 Sun 1 1/4/2021 Mon 1 1/5/2021 Tue 1 1/6/2021 Wed 1 1/7/2021 Thu 1 1/8/2021 Fri 1 1/9/2021 Sat 1 1/10/2021 Sun 1 1/11/2021 Mon 1 1/12/2021 Tue 1 1/13/2021 Wed 1 1/14/2021 Thu 1 1/15/2021 Fri 2 1/16/2021 Sat 2 1/17/2021 Sun 2 Please check this update
=MOD(ISOWEEKNUM(E4-WEEKDAY(E4,15)),53)+(ISOWEEKNUM(DATE(YEAR(E4),1,1))=53)
