Formatting

Giganews Newsgroups
Subject: Formatting
Posted by:  nick
Date: Fri, 19 May 2006

im comparing dates from two workbooks. In workbook 1, i converted YYYYMMDD
format to MM/DD/YYYY to compare it with a date in workbook 2. I put an if
statement saying if(wk1a1=wk2a1,"Pass","fail")...but somehow im getting a
fail...even tho the dates in both workbooks looks the same and in the same
format. can someone help me in this? thanks

Replies