I want to count how many cells have a date.
I am trying to find a way to count how many cells in my column have a date in it.
I use the formula =COUNT([Target Launch Date]6:[Target Launch Date]24) but it always appears the error code #DATE EXPECTED.
I tried the same formula on other columns with text and it works perfectly fine.
I also tried =COUNTIF([Target Launch Date]6:[Target Launch Date]24, <>"") but it gives the same result.
Can someone help me?
Help Article Resources
Check out the Formula Handbook template!