search for all record on excel that is in octorbor 2012

colume a is for mate datetime on excel how can i find where date time is on octorber 2012
teeraAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Another way is to use data filter.

If you have 2007 or later then you can simply select the desired month from the filters.
In earlier versions you will have to give a < and > criteria.
0
 
FlysterCommented:
Try this:

=SUMPRODUCT(--(MONTH(A:A)=10),--(YEAR(A:A)=2012))

Flyster
0
 
flaphead_comConnect With a Mentor Commented:
use conditional formatting.  
Select the range
select conditional formatting
Select Use a formular to determine which cells to format
In the formula us:
=MONTH($A2)=10

Pick a fill colour
Click OK
Make sure the "applies to" is okay and click Apply
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.