•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Counting date entries in csv spreadsheet
Our take
If you're looking to count date entries in your CSV spreadsheet effectively, it's essential to account for the time component in your data. Using the COUNTIF function as you described may yield unexpected results because it considers the full timestamp. Instead, try utilizing the COUNTIFS function combined with the DATE function to accurately count entries for each specific day. For instance, you can use a formula like `=COUNTIFS(B2:B1479, ">="&DATE(2025,8,19), B2:B1479, "<"&DATE(2025,8,20))` to count all entries
I have entries similar to the ones below. I have 1500 rows of data. Out of this, all I care about is how many entries I got each day. So for 8/19/2025 id like it to return 2, 8/20/2025 it returns 4 and so on. I was going to do a countif command using =COUNTIF(B2:1479, 8/19/2025) then =COUNTIF(B2:1479, 8/20/2025) but it returns 0 for both. I assume its looking at the time in the value so it does not meet the criteria.
8/19/2025 13:51:20 PM
8/19/2025 18:52:01 PM
8/20/2025 10:42:01 AM
8/20/2025 10:43:01 AM
8/20/2025 10:43:01 AM
8/20/2025 15:06:01 PM
1/20/2026 3:07:01 AM
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Countifs function comparing the number of occurrences of a value within a date range without having to change the date for every cell?https://preview.redd.it/5wv7p6qq6dvg1.png?width=1523&format=png&auto=webp&s=8678f87180d0cf5c410d2f14fdaefc77ca4dc255 I am a self-taught excel newbie and am trying to help automate the calculation of the stats at my job (meaning I will likely be back with multiple more questions). For this problem, I am trying to get the data to automatically calculate as information is entered in another sheet to determine how often certain values (e.g. "Academic") appear within each month. For some reason, when I put the cell (H2) in place of the date, excel does not register it as a cell and will not complete the calculation. The only solution I have found is to have to individually type out each date range rather than referring to the cell that contains the date range. Further, is there a way to not have to include the year? in this job, we have a separate file for every school year meaning there will be no overlap of month causing issues that way. I am trying to find an easier way to do a year to year comparison without having to include helper columns with the beginning and end dates of each month per year. https://preview.redd.it/55l3ixa49dvg1.png?width=1140&format=png&auto=webp&s=3b222fe0266778a2645f72fed52b59efae4ed850 Thank you! submitted by /u/mentallylost14 [link] [comments]
- Counting longest spurt of consecutive cells with valueHey y’all! In my data I have a row for every 6 hours for 12 months and a column with varying values for each row. Like, A B 1/1/2026 0:00 -9.76 1/1/2026 6:00 -12.54 etc. I need to count what was the longest length of time the values were above -12 for the entire year. Any ideas on how to do this? I’m open to any solutions be it formulas, power query, or macros/VBA. I’m on 365 on a desktop. I’m currently cleaning up a bunch of data sheets other people made and this is a task we have to do frequently. In this workbook I’ll have to do it on 20+ columns and then do it again on each column for subsets of the time we have data for. Their current solution is a C column with =IF(B2>=-12,C2+.25,0) to count the days >-12 in a row in 6 hour increments. Then in column D they have =IF(C3>C2+C4,C3,0) to have a column with just the max value of each consecutive spurt of time. At the end they run =MAX(D2:D1459) to get the longest spurt. Then they add 2 more columns for each subset of time they want to look at. It takes up half the workbook. submitted by /u/CompetitiveDuck495 [link] [comments]
- Counting / Summing Dates (in Google Sheets)I want to count how many events occur on which days of the week. The data below would create the following result; https://preview.redd.it/qofb3ncnpfpg1.png?width=127&format=png&auto=webp&s=ad59949b8df291c296adccf103928934cb3b9cba Mon=1 Tue=0 Wed=0 Thu=1 Fri=1 Sat=0 Sun=0 Is it possible to retrieve this data from the formatted text result. The data in the cells are 16/03/2026, 19/03/2026, 20/03/2026. The date column is column A. Failing that, is it possible to have a command in B1 that will automatically copy all the text from A. The formatted text, not the contents. Because then I can just ask for cells including "Mon" with =COUNTIF(A2:A340, "*Mon*") (crossposted to r/googlesheets , will reply with answer if found there) submitted by /u/Objective-Angle-6574 [link] [comments]
- 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. https://preview.redd.it/ulv6qcql3vwg1.png?width=75&format=png&auto=webp&s=bf2d69f7b5cfae14f09afb49b1f24c25a1b9c2b6 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 submitted by /u/UnicodeConfusion [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#rows.com#natural language processing for spreadsheets#real-time data collaboration#big data management in spreadsheets#conversational data analysis#Excel compatibility#intelligent data visualization#real-time collaboration#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software