Formatting

N

nick

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
 
S

swatsp0p

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

HTH

Bruc
 
N

nick

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
 
A

Abode

Is that the exact formula and are wk1a1 and wk2a1 labels or named ranges. If
not you may be pointing to no or a wrong location. Maybe try putting =wk1a1
and =wk2a1 in two empty cells to check what value they are getting. Also you
can always use Tools > Formula Auditing > Evaluate Formula to see exactly
what the computer is seeing and doing. Hopefully that helps out.
 
R

RagDyeR

Try something like this:

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


--

HTH,

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

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
 
Top