Forum Discussion
counting dates
I 've got a file from https://cneos.jpl.nasa.gov/fireballs/ I removed all columns but the first one. The first column shows the dates when a fireball was observed. I need to arrange it in this fo...
Use COUNTIFS() function with dates criterial. Try following function as per screenshot. Also see attached file.
=COUNTIFS(A:A,">="&DATE(B2,C2,1),A:A,"<="&EOMONTH(DATE(B2,C2,1),0))
- Thanks, but it does not seem to work. Do I need to do it line by line? I am trying to automate it so that it can be done for all lines at once.
First, it work as it can been in the uploaded workbook.
Second, you can do it with a pivot table.
Peak Brightness Date/Time (UT) in rows area and group by years and months and sort in descending order.
Peak Brightness Date/Time (UT) in values area. If necessary change the aggregation to Count.
