•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to count unique days in a list of dates?
Our take
Counting unique days in a list of dates can enhance your data analysis by providing clearer insights. If you're looking to determine the number of distinct days by year without using a pivot table, Excel offers a straightforward approach. Instead of using the COUNTIFS function, which counts occurrences, you can utilize the combination of the UNIQUE and COUNTIF functions to isolate unique dates. This method will allow you to accurately reflect the number of unique days for each year in your dataset.
I have a list of dates like below and want to get the values of number of days by year. So in the example below it would be 2025 = 2 (10/09 and 09/28) and 2026 = 5 -- I don't want a pivot table but I did try
=COUNTIFS(C16:C988,">="&DATE(2024,1,1),C16:C988,"<"&DATE(2025,1,1))
which would give me a total by year (in this case 2024. But that doesn't get the unique days. Excel for Mac is the software Thanks for any help.
| 2026-04-08 |
|---|
| 2026-04-03 |
| 2026-04-03 |
| 2026-03-30 |
| 2026-03-30 |
| 2026-03-25 |
| 2026-03-25 |
| 2026-03-24 |
| 2026-03-24 |
| 2025-10-09 |
| 2025-09-28 |
| 2025-09-28 |
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#rows.com#digital transformation in spreadsheet software#unique days#number of days by year#list of dates#Excel#COUNTIFS#Excel for Mac#date function#pivot table#total by year#2025#2026#date range#values