Skip to content
Adaptam Docs

COUNT_DATE_UNIQUE

Count of unique date values in cells, ranges, or data fields. Non-date values (text, numbers, blanks/empty cells, errors) are ignored. Duplicates are counted once.

Function syntax

COUNT_DATE_UNIQUE(input1, ...)

Arguments:

  • input1, …: One or more dates, cells, ranges, or data fields.

Examples

  • COUNT_DATE_UNIQUE(A1:A5) - If A1:A5 contains 2024-01-15, 2024-02-20, 2024-01-15, (empty cell), hello, returns 2. Non-dates are ignored; duplicate date is counted once.
  • COUNT_DATE_UNIQUE(order_date{}) - Count of unique values in the order_date field.
  • COUNT_DATE_UNIQUE(order_date{country{“US”}}) - Count of unique values in the order_date field where country is US.
  • COUNT_DATE_UNIQUE(order_date{}, C10:E15) - Count of unique date values across the order_date field and the range C10:E15 combined.