count number customers briefed by quarter

bshokrol

Hi, 

I have a date column which shows the date we briefed a customer, I want to determine how many customers we briefed in each quarter and eventually by month. The column property is "date" and I cannot change that. 

 

=COUNTIFS([Date Briefed:Date Briefed], >DATE(2017,07,31), [Date Briefed:Date Briefed],<DATE(2017,11,01))

I tried this but the result is unparsable

I have tried not using the DATE function but that doesn't work either. Any suggestions?

--B

Mike Wilday

If your Column headers contain spaces surround each reference with brackets. I was able to run a similar formula on End dates in a text/number formatted column. 

=COUNTIFS([Date Briefed]:[Date Briefed], >DATE(2017,07,31), [Date Briefed]:[Date Briefed],<DATE(2017,11,01))