how do i make and if then to long or short te

March 22, 2011 at 07:41:44
Specs: Windows 7
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!!


See More: how do i make and if then to long or short te

Report •

#1
March 22, 2011 at 12:13:39
Try this:

With your purchase date in cell A1

=IF(DATEDIF(A1,TODAY(),"d")>365,"Long","short")

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question