Perform Count of another column based on another column date range

Perform Count of another column based on another column date range

Hi, I would like to count distinct "Deals.ID" column based on "Deals.Created Time" column, any inputs, I tried existing threads I didn't find any reference.

I am trying to use this in Pivot Table (formula)