Forum Discussion

AlexPAA's avatar
AlexPAA
Copper Contributor
Jan 23, 2023

Counting days in excel

This isn't as simple as it sounds. 

 

I want to count the number of days in a column on each day.  

 

So we have this column with dates when we have contracts signed. I'm trying to find when our busiest time of the month is (ie when most contracts are signed.) - then put it into a graph. 

 

Looking through the column looking of 1st of the month every year and counting, then looking through for the 2nd of the month and adding to a count, then the 3rd etc. 

 

Then in the same, counting how many in each month. Is this possible? 

BI & Data Analysis
Charting
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Jan 23, 2023

    AlexPAA 

    =SUMPRODUCT((DAY($B$3:$B$153)=E3)*$C$3:$C$153)

    Is this similar to what you are looking for? The days in column B are from 1st of January to 31st of May in the example (range B3:B153). For the count of months the formula can be adapted accordingly.

     

Resources