Date count formula

Steve 444

I am using this formula to count dates from a column but still get #UNPARSEABLE error. Date column I am referencing is connected to an index sheet, but it is had manual entry and formulas there as well. Not sure how to correct. Thanks

=COUNTIFS([Project End Date]10:[Project End Date]619, "<"&TODAY())

heyjay

=COUNTIF([Project End Date]:[Project End Date], < TODAY())

And make sure your column's property is a DATE column.

heyjay

=COUNTIF([Project End Date]:[Project End Date], < TODAY())

And make sure your column's property is a DATE column.

Steve 444

Thanks, appreciate the help