Date in a CountIf formua

kbarhoover

I want a calculation that displays a summary of how many records have a complete date greater than or equal to 1/1/2017. 

 

Here is what I add to the cell:

="Unassigned: " + COUNTIFS(LOB:LOB, "ERx", [COMPLETE DATE]:[COMPLETE DATE], >=1/1/2017)

 

Then I get an "Invalid Operation" messag and SS adds spaces to the date portion of the formula:

="Unassigned: " + COUNTIFS(LOB:LOB, "ERx", [COMPLETE DATE]:[COMPLETE DATE], >=1 / 1 / 2017)

 

Help!

Adam Overton

It looks like it is parsing 1/1/2017 as 1 divided by 1 divided by 2017, which is not what you want. Consider using the DATE(year, month, day) formula.

 

kbarhoover

Worked like a charm!

="YTD Complete: " + COUNTIFS(LOB:LOB, "ERx", [COMPLETE DATE]:[COMPLETE DATE], >=DATE(2017, 1, 1))

 

Thanks!!