formula to recognize which month and year is and count it

georgepre10

New Member
Joined
Jan 22, 2021
Messages
13
Office Version
  1. 2019
Platform
  1. Windows
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!!
 

Attachments

  • Screenshot 2022-03-13 024452.png
    Screenshot 2022-03-13 024452.png
    38.7 KB · Views: 22

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
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
BC
1
2Date/Time
312/03/2022 19:311
412/03/2022 19:31 
513/04/2022 19:314
614/04/2022 19:31 
715/04/2022 19:31 
816/04/2022 19:31 
925/05/2022 19:312
1025/05/2022 19:31 
1130/05/2022 19:31 
Days in month
Cell Formulas
RangeFormula
C3:C11C3=IF(TEXT(B3,"my")=TEXT(B2,"my"),"",COUNT(UNIQUE(FILTER(DAY(B3:B$10000),TEXT(B3:B$10000,"my")=TEXT(B3,"my")))))
 
Upvote 0
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?
 
Upvote 0
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.

1647171289012.png
 
Upvote 0
Upvote 0

Forum statistics

Threads
1,223,320
Messages
6,171,434
Members
452,402
Latest member
siduslevis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top