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
Solved! Go to Solution.
Oh...Excel! Sorry to hear that.
Change the 'Last Date' in the formula to: DateValue('Last Date')
What is the error you are getting, and what kind of column is 'Last Date' in your Data list?
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.
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.
Oh...Excel! Sorry to hear that.
Change the 'Last Date' in the formula to: DateValue('Last Date')
Thank you!!
it worked.