Help with a formula

[Mariela1327]

Is there a formula that can count based on dates?

Here's the scoop.

I created a spreadsheet which I would like for it to track trainings based on days, I added an =COUNTA(A1:A100) formula which counts the amount of people trained but what happens is that it counts people trained all week long. I want it to be able to differentiate days and display the amount of people trained per day , Ex. 4 on Mon, 5 of Tue , 6 on Wed, etc

Thank you!

 

[liiamra]

Hi Mariela,

You have many options, such as countif, but could you first show the structure of the base sheet?

Regards+
LA