Formatting
 

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

Formatting
 

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

Formatting
 

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

Formatting
 

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.

"nick" wrote:

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

Formatting
 

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