Link to home
Start Free TrialLog in
Avatar of MrTV
MrTVFlag for Thailand

asked on

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
Avatar of Flyster
Flyster
Flag of United States of America image

Try this:

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

Flyster
SOLUTION
Avatar of flaphead_com
flaphead_com
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial