Formula to calculate unique number of days falls under a particular month.

[Zee996]

Hello,

Need help in determining the unique count of days within a specific month. Could you please help me with that? Thank you!

Here how my dataset looks like:

Date
29-01-2024​
03-12-2023​		Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24
13-11-2023​
14-11-2023​		no. of days under the particular month.
15-12-2023​
17-11-2023​
09-11-2023​
06-01-2024​
08-01-2024​
01-11-2023​
01-03-2024​
01-11-2023​
01-11-2023​
01-04-2024​
01-11-2023​
01-11-2023​
01-11-2023​
02-11-2023​
01-11-2023​
01-11-2023​
01-11-2023​

 

[Georgiboy]

Here's one option:

Book2
	A	B	C	D	E	F	G	H
1	Date		01/11/2023	01/12/2023	01/01/2024	01/02/2024	01/03/2024	01/04/2024
2	01/11/2023		14	2	3	0	1	1
3	01/11/2023
4	01/11/2023
5	01/11/2023
6	01/11/2023
7	01/11/2023
8	01/11/2023
9	01/11/2023
10	01/11/2023
11	02/11/2023
12	09/11/2023
13	13/11/2023
14	14/11/2023
15	17/11/2023
16	03/12/2023
17	15/12/2023
18	06/01/2024
19	08/01/2024
20	29/01/2024
21	01/03/2024
22	01/04/2024
Sheet1

Cell Formulas
Range	Formula
C2:H2	C2	=COUNTIFS($A$2:$A$22,">="&C$1,$A$2:$A$22,"<="&EOMONTH(C$1,0))

 

[Zee996]

=COUNTIFS($A$2:$A$22,">="&C$1,$A$2:$A$22,"<="&EOMONTH(C$1,0))

Thank you for this. But I want unique dates that falls under a month. Would it be possible?

 

[Georgiboy]

Sorry, neglected that point.

Here's another option:

Book2
	A	B	C	D	E	F	G	H
1	Date		01/11/2023	01/12/2023	01/01/2024	01/02/2024	01/03/2024	01/04/2024
2	01/11/2023		6	2	3	0	1	1
3	01/11/2023
4	01/11/2023
5	01/11/2023
6	01/11/2023
7	01/11/2023
8	01/11/2023
9	01/11/2023
10	01/11/2023
11	02/11/2023
12	09/11/2023
13	13/11/2023
14	14/11/2023
15	17/11/2023
16	03/12/2023
17	15/12/2023
18	06/01/2024
19	08/01/2024
20	29/01/2024
21	01/03/2024
22	01/04/2024
Sheet1

Cell Formulas
Range	Formula
C2:H2	C2	=LET(d,$A$2:$A$22,IFERROR(ROWS(UNIQUE(FILTER(d,(d>=C1)*(d<=EOMONTH(C1,0))))),0))

 

[Zee996]

Sorry, neglected that point.

Here's another option:

Book2
	A	B	C	D	E	F	G	H
1	Date		01/11/2023	01/12/2023	01/01/2024	01/02/2024	01/03/2024	01/04/2024
2	01/11/2023		6	2	3	0	1	1
3	01/11/2023
4	01/11/2023
5	01/11/2023
6	01/11/2023
7	01/11/2023
8	01/11/2023
9	01/11/2023
10	01/11/2023
11	02/11/2023
12	09/11/2023
13	13/11/2023
14	14/11/2023
15	17/11/2023
16	03/12/2023
17	15/12/2023
18	06/01/2024
19	08/01/2024
20	29/01/2024
21	01/03/2024
22	01/04/2024
Sheet1

Cell Formulas
Range	Formula
C2:H2	C2	=LET(d,$A$2:$A$22,IFERROR(ROWS(UNIQUE(FILTER(d,(d>=C1)*(d<=EOMONTH(C1,0))))),0))

This works! Thank you so much.