CountRows and Filter function to count overdue dates

[noamshn]

hello everyone,

I want to to make text label that will show me the number of data the is overdue. I used CountRows and Filter for this.

The problem is that I keep getting error for some reason and I think its because of the format of the date.

I would like to hear your suggestions.

Thank you in advace

[RandyHayes]

@noamshn 

What is the error you are getting, and what kind of column is 'Last Date' in your Data list?

[noamshn]

@RandyHayes 

The error is: Invalid argument type. Expecting one of the following: Number, Date, Time, DateTime.

how can I check what kind of column it is? It suppose to be Date column but I didnt define it to be like it, I just added this column in my excel file.

[noamshn]

The error is: Invalid argument type. Expecting one of the following: Number, Date, Time, DateTime.

how can I check what kind of column it is? It suppose to be Date column but I didnt define it to be like it, I just added this column in my excel file.

[RandyHayes · Accepted solution]

@noamshn 

Oh...Excel!  Sorry to hear that.

Change the 'Last Date' in the formula to: DateValue('Last Date')

[noamshn]

Thank you!!

it worked.