Forum Discussion

florinnitu's avatar
florinnitu
Copper Contributor
Mar 02, 2023

Count number of days in a column

Hi,   I have a column in Excel containing data as below:   12 February 2023 12 February 2023 12 February 2023 13 February 2023 13 February 2023 1 March 2023 1 March 2023 2 March 2023   I...
excel
Formulas and Functions
Hecatonchire's avatar
Hecatonchire
Iron Contributor
Mar 02, 2023

Hi,

 

For each of the 12 months (! same year)

 

=FREQUENCY(Month(UNIQUE(D4:D14)),SEQUENCE(11,,1))

Change D4:D14

 

 

florinnitu