Current Week for Period

I'm trying to use a formula to identify the "Current Week" in my file. The file calculates the reporting period based on the date the new row is created. It also calculates the reporting week number based on the period ending date. The issue is that when I use the WEEKNUMB function to calculate the "Current Week" it does not work on Sundays. It actually leaves that cell blank. I'm using the following formula:

=IF(AND(Year@row = "Current Year", WEEKNUMBER(Added@row) -1 = [Week Number]@row), "Current Week")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!