[ 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.
To count how many weeks between two dates, you can use the below handy formula, just subtract start date from the end date and divide by 7: 1. Enter this formula =(B2-B1)/7 into a blank cell, (B2 indicates the end date and B1 is the start date), see screenshot: