Morning all,
I'm trying to use an "IF" statement to look at a date in a cell and if it matches the criteria return the information from another cell. I have tried several different ways and constantly receive an improper "FALSE". Attached is a simplified example. I'm sure it's a simple soultion, but just the same I would appreciate the help.
thanks
Last edited by scaffdog845; 10-23-2008 at 10:55 AM. Reason: Solved
=IF(B2=DATE(2008,10,23),A2)
Your formula asks: "is B2 (which is actually the number 39744 formatted to look like a date to you and me) the same as the string (i.e. the word) "10/23/08", which has a numeric value of 0?"
39744 = "10/23/08"?
The answer is no...
You can use datevalue(string), e.g. datevalue("10/23/08") to coerce a string date to a true date, but date(<year>,<month>,<day>) as shown above, will cause fewer problems if you ever have to exchange information between Americans and people who choose to write dates out in the right order. For this reason alone I'd recommend the habit of using date() over datevalue() as good practice for the future.
HTH
Works great thank you. Every time I post I learn something new. One more quick question... How do I flag my post as being solved?
In your formula: =IF(B2="10/23/2008",A2)
"10/23/2008" is text to Excel.
However, you can coerce the text value to a number (date, in this case)
by applying an arithmetic operator (+,-,/,*) to that text.
The generally accepted convention for coercing text to numbers
is to use a double-minus.
Try this:
Does that help?
Please Login or Register to view this content.
to mark a post as solved:
1) Click the EDIT button on your first post
2) Click the GO ADVANCED button
3) Select SOLVED from the Title dropdown (under the Reason for Editing box)
4) Click the SAVE CHANGES button
--
Regards
PD
----- Don't Forget -----
1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
2. Thank those who have helped you by Clicking the scales above each post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks