Mariela1327
New Member
- Joined
- Apr 30, 2014
- Messages
- 1
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!
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!