[ Note: It is official that men who play guitar are more attractive, this study confirms. ] The theory behind this is really simple. An astonishing number of 9 out of 10 females agree to the fact that they find guitarist way sexier than an average male.
I want to have two dates within the if statement. This is what I made, but i need it corrected. =IF(J2>DATEVALUE(5/31/2014),GOOD,EXPIRED J2>DATEVALUE(6/31/2014),GOOD,EXPIRING SOON) See More: EXCEL If Statement Using Dates.
formula comparing two dates. I have a formula that compares two dates and should return one of them but something's not working! The formula is: =IF(stdate.pbf&LT;12/31/2000,TEXT(stdate.pbf,MMMM D, YYYY),TEXT(date1,MMMM D, YYYY)). When the value for stdate.pbf is greater than 12/31/2000, this works.e: formula comparing two dates. Well, after playing with this for awhile, I'm even more confused! In scenario #1; stdate.pbf = 4/28/1992 and date1 = 12/31/1999. Using my formula, 4/28/1992 is the value returned. In scenario #2; stdate.pbf = 2/09/2001 and date1 = 12/31/99.