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

  • Sing C
    Sing C Community Champion

    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.

    image.png


    Thanks,

    Sing

    Sing Chen

    Process & Solutions Architect, Dayforce

    LinkedIn

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!