•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
isoweeknum formula not rolling over the years
I am trying to correct the formula (picture below focusing on the formula in cell C29 for reference) I can't get the year to switch over to 2026 or 2027 etc.. 26wk53 (cell C27) should also start as 27wk1. the two formulas below are the two formulas I've been using that give me the same issue.
=TEXT($C$1,"YYwk")&TEXT(WEEKNUM($C$1,21),"00")-(AND(MONTH($C$1)=12,WEEKNUM($C$1,21)=1))
=YEAR($C$25+3-MOD($C$25-2,7))*100+ISOWEEKNUM($C$25)
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#isoweeknum
#formula
#YEAR
#WEEKNUM
#TEXT
#cell
#C29
#C27
#2026
#2027
#MOD
#AND
#MONTH
#wk