Forum Discussion
florinnitu
Mar 02, 2023Copper Contributor
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...
Hecatonchire
Mar 02, 2023Iron Contributor
For a months column
=hstack(Text(SEQUENCE(11,,1)*30,"mmmm"),FREQUENCY(Month(UNIQUE(D4:D14)),SEQUENCE(11,,1))