•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?
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]
Want to read more?
Check out the full article on the original site
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