[ 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.
PRINT DATEDIFF(DAY, '1/1/2011', '3/1/2011') will give you what you're after. This gives the number of times the midnight boundary is crossed between the two dates.You may decide to need to add one to this if you're including both dates in the count-or subtract one if you don't want to include either date. share | improve this answer. answered May 20 '11 at 6:03.his gives the number of times the midnight boundary is crossed between the two dates. You may decide to need to add one to this if you're including both dates in the count-or subtract one if you don't want to include either date. share | improve this answer.