Current Week Formula
I use the formula listed below quite often but sometimes different variations. I am having trouble with this specific one because it is pulling the previous year's entries as well when I only want the current year. I have tried a couple of things but can't seem to get the syntax right. I think I need to use something like YEAR(Date@row) = YEAR(TODAY() but can't seem to get it. Any suggestions? @Paul Newcome I think you were the one to help me with learning this formula a while back! Do you mind assisting? Thank you!
=IF(WEEKNUMBER(Date@row) = WEEKNUMBER(TODAY()), 1)
Help Article Resources
Check out the Formula Handbook template!