Week Number stopped working
I'm a little stumped, I have a formula that worked great until last week when it stopped working. I figured it was just because it was week 1 and week 52 in the same week and figured it would all start working this week. No dice, any help is appreciated.
The formula is a helper column that is meant to count the number of installs per week.
=IF(ISBLANK([Date AP Patched (Vendor)]@row), "", IF(WEEKNUMBER([Date AP Patched (Vendor)]@row) <= WEEKNUMBER(TODAY()), WEEKNUMBER([Date AP Patched (Vendor)]@row) >= WEEKNUMBER(TODAY() + 1), 1))
Help Article Resources
Check out the Formula Handbook template!