SUMIF - looking forward a few months returning a zero after year end
I have this formula to look forward a few months a but once we get into the next year (2022) the result is 0. I've tried several ways but get the same 0 result. What am I missing. Thanks in advance!
=SUMIFS([Man Days]:[Man Days], [Start Date]:[Start Date], AND(IFERROR(MONTH(@cell), 0) = IF(MONTH(TODAY()) = 1, 12, MONTH(TODAY()) + 2), IFERROR(YEAR(@cell), 0) = IF(MONTH(TODAY()) = 1, YEAR(TODAY()) - 1, YEAR(TODAY())))) * 8
Answers
-
Not sure what is going on without more contexts. The criterion1 portion of that formula might have some issues. Try using the DATE formula in the criterion1. The formula below looks at the Start Date column and counts everything in the Man Days column that is greater than 30 days from todays date. Hopefully you can alter this to fit your needs.
=SUMIFS([Man Days]:[Man Days], [Start Date]:[Start Date], DATE(YEAR([Start Date]@row), MONTH([Start Date]@row), DAY([Start Date]@row)) > TODAY(30))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!