CountIFS based on rolling FY and item.
I am trying to count how many of X has been completed (based on completion date) in the current FY based. Ideally I'd like the count to automatically update what the current FY is.
I think this should be a simple formula, but for some reason, I'm at a loss.
Thanks in advance for your help.
Help Article Resources
Check out the Formula Handbook template!