Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

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
0
teera
Asked:
teera
2 Solutions
 
FlysterCommented:
Try this:

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

Flyster
0
 
flaphead_comCommented:
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
 
Saqib Husain, SyedEngineerCommented:
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now