Skip to content
Adaptam Docs

COUNT_DATE

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

Function syntax

COUNT_DATE(input1, ...)

Arguments:

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

Examples

  • COUNT_DATE(A1:A5) - If A1:A5 contains 2/20/24, hello, 2/20/24, (empty cell), 100, returns 2. Text, numbers, and blanks/empty cells are ignored.
  • COUNT_DATE(order_date{}) - Count of values in the order_date field. Blanks are not counted.
  • COUNT_DATE(order_date{country{“US”}}) - Count of values in the order_date field where country is US.
  • COUNT_DATE(order_date{}, C10:E15) - Count of date values across the order_date field and the range C10:E15 combined.