Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |