[ 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.
Result: Now we want to get the number of days between two dates (notice that the second date is earlier than the first date, and will result in a negative number).We use the following SELECT statement: SELECT DATEDIFF(day,'2014-08-05','2014-06-05') AS DiffDate. Result:esult: Now we want to get the number of days between two dates (notice that the second date is earlier than the first date, and will result in a negative number).