•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
Our take
Struggling with the isoweeknum formula not rolling over the years can be frustrating, especially when your data needs to reflect accurate week numbers for 2026 or 2027. This issue often stems from how dates are formatted and calculated. In this guide, we’ll explore why your formulas might be returning the same results and how to adjust them for seamless year transitions. Keep reading to uncover specific adjustments that will enhance your spreadsheet’s functionality and ensure accurate weekly data tracking.
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]
Read on the original site
Open the publisher's page for the full experience