Hi everyone,
I don't understand what's wrong with my formula, I am trying to count the number of received dates each month within that year with the following function:
COUNTIFS(MONTH('(DL here) queryTool'!$B$2:$B$48095),"="&'Graph 1 - Monthy Registered'!A5,YEAR('(DL here) queryTool'!$B$2:$B$48095),"="&'Graph 1 - Monthy Registered'!$A$4)
I have made a sample and uploaded it on OneDrive if you would like to have a look.
Thanks
https://1drv.ms/x/s!AgQdYsSdg735f8VN4vTtXjQMW5c
I don't understand what's wrong with my formula, I am trying to count the number of received dates each month within that year with the following function:
COUNTIFS(MONTH('(DL here) queryTool'!$B$2:$B$48095),"="&'Graph 1 - Monthy Registered'!A5,YEAR('(DL here) queryTool'!$B$2:$B$48095),"="&'Graph 1 - Monthy Registered'!$A$4)
I have made a sample and uploaded it on OneDrive if you would like to have a look.
Thanks
https://1drv.ms/x/s!AgQdYsSdg735f8VN4vTtXjQMW5c