count number of times that date > todays date

[#1]

Hi,

Im trying to count the number of times the deadline date has been exceeded for all open project items.

Count({<[Target Date] > date(today()), [Status]={"Open"}>}[Target Date])

I've done this, but there is an issue with it. I am trying to say, count the number of times [Target Date] is before todays date

[sunny_talwar]

May be this:

Count({<[Target Date]  = {">$(=Date(Today(), 'YourTargetDateFormatHere'))"}, Status= {'Open'}>} [Target Date])

[Anonymous · Accepted solution]

may be like this?

=Count({<[Target Date] ={'>$(=date(today(),'DateFormat'))'}, [Status]={"Open"}>} distinct [Target Date])

make sure format of [Target Date] & DateFormat should be same