[ 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.
DATEDIF function explicitly gives you the number of months between two dates-it rounds down. =DATEDIF(A2,B2,m). where A2 is the earlier of the two dates. If you want to round to the nearest whole month you can use this version. =DATEDIF(A2,B2+15,m).If you don't care about the day and any date in Jan to any date in March is 3 months then you can use this version.=DATEDIF(A2-DAY(A2)+1,B2,m)+1.here A2 is the earlier of the two dates. If you want to round to the nearest whole month you can use this version. =DATEDIF(A2,B2+15,m). If you don't care about the day and any date in Jan to any date in March is 3 months then you can use this version. =DATEDIF(A2-DAY(A2)+1,B2,m)+1.