date compare problem

[johndem33]

I need assistance in figuring out how to compare a literal to a cell that actually references another cell. My literal comparison is checking for which day of the week is in a cell. For example, let's say cell address 'A1' contains the date in the following format: 'day, month day, yyyy' format, like 'Tuesday, April 20, 2010'. Cell address 'A2' is a refence to '+A1' and 'A2' has been formatted using the Custom format of 'dddd'. So, 'A2' displays 'Tuesday'. In 'A3', I've entered the following formula: =If(A2="Tuesday","True","False"). My problem is the formula is returning 'False', but I can see that 'A2' is displaying 'Tuesday'! I suspect that the problem is I don't have an exact match in my formatting of 'A2' is likely masking it's real contents of 'Tuesday, April 20, 2010'. Is there a way to get around this and make my formula work?

 

[littleiitin]

YOU CAN TRY THIS ONE

=ISNUMBER(SEARCH(TEXT(A2,"dddd"),TEXT(A1,"dddd")))

 

[ukmikeb]

Hi

Welcome to the forum.

If you assign a cell to the value of another cell it retains the content of that cell irrespective of the formatting that you apply.

So, in this case A2 will be a Date.

Put the following in A3 to solve your problem :-

=(WEEKDAY(A1,2)=2)

hth

Mike

 

[Sandeep Warrier]

Or

=IF(TEXT(A2,"dddd")="Tuesday",TRUE,FALSE)
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[johndem33]

Thank you three very much! I learned a lot this evening because of your assistance. Wishing you a fantastic day!

John in Dallas, Texas