countif with dates
Can anyone tell me what might be wrong with this formula?
I'm trying to count the number of items that are complete, as noted by the presence of a date in the date completed field. I need to know the number of fields that have a date in 2018. Thanks
=COUNTIF([Date Completed]1:[Date Completed]14, "=>1/1/18")
Help Article Resources
Check out the Formula Handbook template!