Cross Sheet Reference Formula
I am trying to write a cross reference sheet formula to count MTD dates in a column using this formula I found here but it is not working. Thoughts?
=COUNTIFS({Andee Metrics Terms}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), IFERROR(MONTH(@cell), 0 = MONTH(TODAY()))))
Best Answer
-
Is your {Andee Metrics Terms} a date column? Also, we need to rearrange a parenthesis or two
=COUNTIFS({Andee Metric Terms}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), IFERROR(MONTH(@cell), 0) = MONTH(TODAY())))
cheers
Kelly
Answers
-
Is your {Andee Metrics Terms} a date column? Also, we need to rearrange a parenthesis or two
=COUNTIFS({Andee Metric Terms}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), IFERROR(MONTH(@cell), 0) = MONTH(TODAY())))
cheers
Kelly
-
Thank you, yes was a date column, those pesky parenthesis :<
-
😃 Yes, pesky indeed! I wish I had a nickel for every time they have hung my formulas up.
I'm glad we have it working now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!