I want to count how many cells have a date.

Chiara_maz

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?

Sing C

Hi @Chiara_maz,

I have an example below using COUNT which works as expected.

May I ask where you have the formula? As you can see I created a "Count" column and entered the formula in Row 1 of the column. I'm curious where your formula is.

Thanks,

Sing