formula to recognize which month and year is and count it

[georgepre10]

Hello everyone,

i'm trying many hours to figure out how can i solve this problem but no luck

im looking for a formula to recognize which month and year is and count it based on a cell.

For example,

i want in C column next to every entry to count every unique date per month+year (without time). in E column i wrote the result that i want to extract(just the number)

i know that i'm not explaining my problem really well so below is a formula i tried, to understand better and an uploaded image


in C column,
=COUNTA(UNIQUE(INT($B$3:$B$10100))=month(B3)&year(B3)))

Thanks in advance!!

 

[Peter_SSs]

Your profile says Excel 2019 but you appear to be using the UNIQUE function so I am assuming that you have access to all the dynamic array functions.
Do you need to update your account details?

Does this do what you want?

22 03 13.xlsm
	B	C
1
2	Date/Time
3	12/03/2022 19:31	1
4	12/03/2022 19:31
5	13/04/2022 19:31	4
6	14/04/2022 19:31
7	15/04/2022 19:31
8	16/04/2022 19:31
9	25/05/2022 19:31	2
10	25/05/2022 19:31
11	30/05/2022 19:31
Days in month

Cell Formulas
Range	Formula
C3:C11	C3	=IF(TEXT(B3,"my")=TEXT(B2,"my"),"",COUNT(UNIQUE(FILTER(DAY(B3:B$10000),TEXT(B3:B$10000,"my")=TEXT(B3,"my")))))

 

[georgepre10]

thanks for your answer!

i made a mistake i didn't mention that i work on google sheet and not excel

unfortunately the formula returns black in google sheet. any idea?

 

[Peter_SSs]

i made a mistake i didn't mention that i work on google sheet and not excel

In that case your question should not be in the Excel questions forum.

I have moved it to the forum where Google Sheets questions should be asked.

 

[georgepre10]

it worked!!! thank you very much!

 

[Peter_SSs]

unfortunately the formula returns black in google sheet.

it worked!!!

I'm confused!

can i divine a number with this formula you told me?

Possibly, but ..
a) I don't understand what you want, and
b) I generally don't answer Google Sheets questions in this forum.