[ 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.
In the next program, we take a look at how to compare two dates in VBA using CDate() function. Note that to compare dates in VBA, you need to have dates stored in variables of type âDateâ. However, if the dates that you are comparing are entered as numbers or string, you need to convert them using CDate() function. âIf statementâ is used to compare the dates. The following example helps make the concept clear.