# Find number of filled dates if match to perticular cell

#### bhavitparikh2001

##### New Member
Hi Folks,
This might be easy for you but I am sick looking on Google. I have three columns (BF,BG&BH) with dates and column A has various texts that I would like to match with. I run this report everydaya dn spend lot of time to fill tracker manually. I would like to know if from BF (as 3-5 years of dates) filter date to current year and month then look for value in column A (i.e. Radio) and give me number.

A BF BG BH
Radio 12/03/2013 13/03/2013 10/03/2013
Radio 12/04/2013 12/03/2013 10/03/2013

I am after formula to find number of dates in each program.

thanks

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### Akashwani

##### Well-known Member
Hi and welcome to MrExcel.

The following is Sample Data and Example results, does this show what you are wanting to achieve?

Excel Workbook
ABCDEFGHIJK
1TextDate1Date2Date3Filter1Filter2DateTextCount
2Radio01/04/201302/04/201303/04/20133117/04/2013Radio9
3Tv01/04/201302/04/201303/04/201300
4Radio10/04/201311/04/201312/04/201331
5Tv10/04/201311/04/201312/04/201300
6Tv01/03/201302/03/201303/03/201300
7Tv01/04/201202/04/201203/04/201200
8Radio01/04/201202/04/201203/04/201200
9Radio15/04/201316/04/201317/04/201331
10Radio15/04/201216/04/201217/04/201200
11
Sheet14

The formulas in B2:C2 need to be copied down.
You can then filter your results based on Column B or Column C to view the matches.
Or you can use a small table H1:J2 to get the count of the matches.
Or you could just use this formula to get the count....

=SUMPRODUCT(--(YEAR(\$B\$2:\$D\$10)=YEAR(TODAY())*(MONTH(\$B\$2:\$D\$10)=MONTH(TODAY()))*(\$A\$2:\$A\$10="Radio")))

If any of the above does work for you, then you will need to change the cell references to suit your layout.

Ak

Replies
3
Views
380
Replies
13
Views
180
Replies
3
Views
105
Replies
3
Views
83
Replies
1
Views
235

Threads
1,195,936
Messages
6,012,393
Members
441,695
Latest member
MickRobertson

### 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

### 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