Return Current Month
Hi I am trying to pull specific data from a Column when its end date field = current month.
I have gotten this far. =COUNTIF(EndDate:EndDate, IFERROR(MONTH(@cell), 0) = 11, IF(ASite:ASite, 1)) I am getting an incorrect argument error.
Here is what I am trying to do countif a cell in Column Asite is checked=1, and if the date in the cell of EndDate Column = the current month. Right now I was just using Nov or 11 instead of current month
Best Answers
-
Hi @MCSCOO
It looks like you just need the COUNTIFS function, plural! With the S you can go right into the second column reference and second criteria.
Try this:
=COUNTIFS(EndDate:EndDate, IFERROR(MONTH(@cell), 0) = 11, ASite:ASite, 1)
Then if you're looking for the current month, you can use the TODAY function, like so:
=COUNTIFS(EndDate:EndDate, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), ASite:ASite, 1)
Cheers,
Genevieve
-
Thank You, This worked thank you so much !!
Answers
-
Hi @MCSCOO
It looks like you just need the COUNTIFS function, plural! With the S you can go right into the second column reference and second criteria.
Try this:
=COUNTIFS(EndDate:EndDate, IFERROR(MONTH(@cell), 0) = 11, ASite:ASite, 1)
Then if you're looking for the current month, you can use the TODAY function, like so:
=COUNTIFS(EndDate:EndDate, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), ASite:ASite, 1)
Cheers,
Genevieve
-
Thank You, This worked thank you so much !!
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 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