How to count dates/months and put it in a chart?

Do you want to use a pivot table or COUNTIFS() functions? Assuming you only have the date and they are stored as serial numbers, are you allowed to add helper columns?

For counting how many records correspond to each month, a pivot table can "group" dates by whatever time unit you want, including month. So, build your pivot table so it is counting by date, select the "date" field, and instruct Excel to group by month. https://support.microsoft.com/en-us/...c-c84a5a340725

If you prefer to use a COUNTIFS() function, you can count by month by counting records between first and last of a month. =COUNTIFS(dates,dates,">="&DATE(2022,1,1),dates,"<"&DATE(2022,2,1)) will count the records in January. You can use formulas and cell references or other strategy for automating the criteria dates.

For something like "day of the week," you can add a helper column to your source data that extracts "day of the week" from the date using the WEEKDAY() function (https://support.microsoft.com/en-us/...0-e404c190949a ), then use either a pivot table or COUNTIFS() to count by weekday.

Options and choices, and I'm not sure we can make those choices for you, but, if you will help us understand you requirements and constraints and such, we should be able to help come up with a workable solution.

Latest attachment failed to attach. Be sure you are following the instruction for adding attachments at the top of the page.

If you can add columns to the source data, then add columns that will show the desired criteria you wish to count by. For calendar month, you might add a column that uses the MONTH() function to get calendar month for each date value (=MONTH(A2)). Use the WEEKDAY() function to get the day of the week for each date. And so on.

From there it should be straightforward to use the COUNTIFS() function to get the desired counts. Your latest post suggests that there is more to the database than just dates, you also have some kind of Type in each record. To count all "DH" types during the month of Jan 2022:

1) Choose a location for the summary table. (I will start in AA1 for illustration, and assume dates are in column A starting in A2 and types are in column B starting in B2).
2) In AA1 enter "start date." In AB1, enter "end date." In AC1 enter, "Type." In AD1 enter "count" for headers so you can remember what each column is doing.
3) In AA2, enter 1 Jan 2022, In AB2, enter 1 Feb 2022. In AC2 enter, "DH." In AD2 enter =COUNTIFS($A$2:$A$200,$A$2:$A$200,">="&AA2,$A$2:$A$200,"<"&AB2,$B$2:$B$200,AC2)

To count for the first day of the week.

4) In C1 enter, "Day of week." In C2, enter =WEEKDAY(A2) and copy/paste/fill down/
5) In AE1 enter, "Day of week." In AF1 enter "count"
6) In AE2 enter 1. In AF2 enter =COUNTIFS($C$2:$C$200,AE2)

From there, you can add or remove criteria to get whatever combination of criteria you want. Just be clear that COUNTIFS() always use "and" logic when combining multiple criteria. If you are unfamiliar with the syntax of the COUNTIFS() function: https://support.microsoft.com/en-us/...c-aa8c2a866842