 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2006IF month and day match, then...
Hi everyone. Simple question...how would I correct my formula such that if the date in C8 is a certain date (regardless of the year!), then... The formula I tried is: =IF(C8=AND(MONTH(10),DAY(26)),"text") where C8=TODAY(). When I click on the AND in the wizard it says both statements are TRUE but if I click before the AND, it says FALSE. Alternatively, I also tried: =IF(TODAY()=AND(MONTH(10),DAY(26)),"text"). However in the wizard, the result is "Volatile" and the cell displays FALSE. Try something like this: =IF(TEXT(C8,"MMDD")="1026","text","no match") The reason this doesn't work: =IF(C8=AND(MONTH(10),DAY(26)),"text") is that the AND() function regards any positive value as TRUE. Since MONTH(10) is greater than 0 and DAY(26) is greater than 0, then AND(MONTH(10),DAY(26)) returns TRUE Is that something you can work with? *********** Regards, Ron XL2002, WinXP > Hi everyone. Simple question...how would I correct my formula such that if > the date in C8 is a certain date (regardless of the year!), then... The [quoted text clipped - 4 lines] > Alternatively, I also tried: =IF(TODAY()=AND(MONTH(10),DAY(26)),"text"). > However in the wizard, the result is "Volatile" and the cell displays FALSE. Dear Ron, Sorry for the delay but this was the first chance I got to look at these solutions. Thanks for your suggestion, the formula you provided works great! Thank you. > Try something like this: > =IF(TEXT(C8,"MMDD")="1026","text","no match") [quoted text clipped - 19 lines] > > Alternatively, I also tried: =IF(TODAY()=AND(MONTH(10),DAY(26)),"text"). > > However in the wizard, the result is "Volatile" and the cell displays FALSE. Quick update: How would I modify the formula to include other dates? I tried the following but get an #VALUE! error: =IF(TEXT(C8,"MMDD")=OR("1031","0115","0417"),"text","") > Try something like this: > =IF(TEXT(C8,"MMDD")="1026","text","no match") [quoted text clipped - 19 lines] > > Alternatively, I also tried: =IF(TODAY()=AND(MONTH(10),DAY(26)),"text"). > > However in the wizard, the result is "Volatile" and the cell displays FALSE. Hi RS, You were very close, =IF(AND(MONTH(C8)=10,DAY(C8)=26),"text") HTH Simon >Hi everyone. Simple question...how would I correct my formula such that if >the date in C8 is a certain date (regardless of the year!), then... The [quoted text clipped - 4 lines] >Alternatively, I also tried: =IF(TODAY()=AND(MONTH(10),DAY(26)),"text"). >However in the wizard, the result is "Volatile" and the cell displays FALSE.  Signature-------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Dear smw226, Sorry for the delay but this was the first chance I got to look at these solutions. Thanks for your correction to my formula, it now works! It's nice to see that I was on the right track. With the guidance of people such as you and Ron in this forum, I am learning to look for help here rather than waste hours trying to solve an incorrect formula...and in this process, I'm increasing my Excel knowledge! Thanks to everyone! > Hi RS, > [quoted text clipped - 14 lines] > >Alternatively, I also tried: =IF(TODAY()=AND(MONTH(10),DAY(26)),"text"). > >However in the wizard, the result is "Volatile" and the cell displays FALSE. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.