Extract data from my input table to use in pivot charts

[Selander]

Hello there!

I am currently constructing a table that tracks some parts of my daily job.
In short it is a table that I update many times each day with a date and a specific code.
This is an example of how the table may look:

Date1	Code1	Date2	Code2	Date3	Code3
26/11/2014	FET	26/11/2014	OKL	20/11/2014	TST
10/10/2014	TLD
23/11/2014	BBB	20/11/2014	FET

I need to track these dates and codes in a pivot table or chart.
I am beginner/intermediate with excel but willing to learn. You do not need to explain every single step in how to get to my end result, just pointers in how to achieve what I want.

What I want:
To count each date that is input. I want a table that lists each date and how many times it occurred. For example using the data from the table above:

Date	Number of times
26/11/2014	2
23/11/2014	1

I also want to know how many times each code appeared each month.
For example:

November	Number of times
FET	2
BBB	1

Note that several cells or rows may be empty and the dates are in no particular order.

I hope this makes sense, if not please let me know and I will try to explain it better.

I am extremely grateful for any help you can provide!

[hoyasaxa215]

Based on my understanding, seems you should be able to perform your desired calculations using the =COUNTIF function. Let me know if that doesn't work.

https://support.office.com/en-us/art...7-e1746e90e55c

[Selander]

I've dived into =COUNTIF and it is great for pulling out the number of dates I have inputted. Thank you for that, its very useful.
However I also need each date in a list that shows how many times the same date have appeared.
As shown in this table below:

Date	Number of times
26/11/2014	2
23/11/2014	1

Do you know how I can achieve this?
Thanks!

[Selander]

I've dived into =COUNTIF and it is great for pulling out the number of dates I have inputted. Thank you for that, its very useful.
However I also need each date in a list that shows how many times the same date have appeared.
As shown in this table below:

Date	Number of times
26/11/2014	2
23/11/2014	1

Do you know how I can achieve this?
Thanks!

I just realized that I can use the =COUNTIFS formula and put the date as a criteria to find out how many are found with that date.
My next question is how I can do this efficiently for each date in a month? Also this data will span a couple of months at least so I don't want to update the formula manually each time I want to look back on a specific date or month..

Update:
Okay I found a way to do what I wanted to achieve with the dates. I used =COUNTIFS with multiple criterias to search for dates between two other dates.

So if I want to find out how many dates are found within October I would use: =COUNTIFS('Input data'!M:R, ">=1/10/2014",'Input data'!M:R, "<=31/10/2014")
This searches and counts all the dates within 1/10/2014 and 31/10/2014.

This is however not ideal since I have to manually enter this formula for each month and make sure I keep in mind how many days are in each month etc. Is there an easier way to do this?

Also, how would I go about looking up how many dates I have inputted for specific weeks?

I appreciate any help I can get.