need to calculate a number of dates entered

OshaK

Hello,

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!

Austin Smith

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

Austin Smith

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

OshaK

thank you @Austin Smith. the easiest one is what i needed. Many thanks!