need to calculate a number of dates entered


what would be the formula to calculate how many dates were entered?

I have 4 date type columns that people can enter or not a date. So i need a total of number of dates entered (not counting if no value in the cell). So it would be number 3 in this example.

thank you!

Best Answer

  • Austin Smith
    Austin Smith ✭✭✭✭✭
    Answer ✓

    Easiest is =countm([additional date 1]@row:[additional date 3]@row)

    if you really need to know whether they're dates...

    =COUNTIF([additional date 1]@row:[additional date 3]@row, >DATE(1950, 01, 01))

    not the most elegant, but it works - something about countif(ref, isdate... seems not to work well


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!