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?



  • Sing C
    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.



    Sing Chen

    Process Architect, Dayforce


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!