[ 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.
This lesson shows you how to use Excel to calculate the number of days between two dates. This might seem like a simple task, and it often is. However, in this lesson we will look at four different scenarios: Calculate how many days there are between two dates, using simple calculations as well as the DATEDIF function.