Excel COUNTA not working

[Holly1165]

I need to count the number of cells with a date in.

I have used =COUNTA(A3:A20)

It counts the amount of cells and NOT the amount with dates in

:(

[#2 · Accepted solution]

@Holly1165 COUNTA counts the number of cells in a range that are not empty. Dates are numbers, so if you only want to add those use COUNT.

[#3]

OMG, what a simple solution! THANK YOU