I have an excel spreadsheet that has the purchase and sale date of investments. How do I create an if then statement to look at the dates and tell me if it is long or short term? It has over 3000 individual trades. The security has to be held for more than 1 year to be long term. Thanks!!
Try this: With your purchase date in cell A1
=IF(DATEDIF(A1,TODAY(),"d")>365,"Long","short")