I'm working on a project where I need to identify Current Week and Last Week. In the below screenshot 08/28/22 is a Sunday (1). 08/28 - 08/31 should show as Current Week but 08/28 shows as Last Week. I've tried to change several things but can not get Sunday to become part of the current week. Any thoughts on what I doing wrong?
=IF(WEEKNUMBER(PlannedComp@row) = WEEKNUMBER(TODAY(1)), "CurrentWeek", IF(WEEKNUMBER(PlannedComp@row) = WEEKNUMBER(TODAY(1)) - 1, "LastWeek", ""))
Help Article Resources
Check out the Formula Handbook template!