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

Tags:

Michiko 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 •

mmcconaghy 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 •

Start a discussion

Related Solutions

› how do i make a cell stay blank
› How do I make the first letter of each word i
› How do I stop Excel help connecting to the in
› [Solved] How do I: if X2 = A2, then change X2 to red?
› how do I make a formula to skip blank cells?
› How do I make MS Word 2010 not run on to a ne
› [Solved] How do I get this IF statement to work?

See More ↓

Ask Your Question

Weekly Poll

Have you ever used Instacart?

Poll Finishes In 6 Days.
Discuss in The Lounge
Poll History