[ 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.
Fortunately, there is a formula can sum up the values between two dates range in Excel. Select a blank cell and type into this formula =SUMIFS(B2:B8,A2:A8,>=&E2,A2:A8,<=&E3), and press Enter button. And now you will get the calculating result. See screenshot: