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?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!