Forum Discussion
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...
If you have Microsoft 365 or Office 2021:
=COUNTA(UNIQUE(FILTER(date_range, (YEAR(date_range)=2023)*(MONTH(date_range)=2))))