[ 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.
Supposing today is 2/15/2014, your vacation starts on 12/25/2013 as following screenshot shown, and you want to count how many days there are between these two dates. In a blank cell, please enter this formula =B2-B1, then press Enter key, and you will get the number of days between the two dates. See screenshots: