Try something like this:

=IF(TEXT(wk1!A1,"yymmdd")=TEXT(wk2!A1,"yymmdd"),"P ass","Fail")


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"nick" wrote in message
...
Hi...i appreciate your concern! Im getting a number when i change the format
to general. so i assume they are true dates. could you tell me what should i
do in both the scenarios? thanks

"swatsp0p" wrote:


Question: Are cells A1 in both sheets truly dates? Remember that Excel
stores dates as a number (e.g. May 19, 2006 = 38856). To check, change
the format of each cell to General and see if you get a number similar
to my example. If not, then you don't have true dates in each cell
(maybe one is a text entry?).

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=543766