In Requests,
Use a helper col I to clean-up col H

In I2, copied down:
=IF(H2="","",IF(ISERROR(SEARCH("GMT",H2)),H2,SUBST ITUTE(H2,MID(H2,SEARCH("GMT",H2),99),"")+0))

Then in your Summary sheet, use:
=SUMPRODUCT((Requests!F2:F100="Review")*(TEXT(Requ ests!I2:I100,"ddmmmyyyy")="09Dec2008"))
to return the desired count

P/s: Remember to press the YES button below ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Raj" wrote:
Hi Max
I am unable to do this if i use the Formula u have give its giving the Value
N/A
Here is the exact sheet format
A B C D E
F G H
31490 XXXX XXXX XXX XXXX Review XXXX December 9, 2008 05:00 PM GMT+01:00

I have placed all the data in the Sheet named Requests. Now i want to pull
the data to Summary Sheet with the Count total incidents which are in review
Status (Colmun F) which are logged on December 9(Column H)

Please do help me to resolve