Spreadsheet: 67095d1267716819-if-statement-help-if-statement-example
Sheet: Jamie N Baker ERN

 |  |  |  |  | Day Count | 5
 | [NAME] and Dates Here |  |  |  |  |  |  |  |  |  |  | ALK Equity
 |  | Alt DE | Ticker/Month/Year | Month | Day | Year | Earnings Day | U/D Before ERN? | U/D After ERN? |  |  | ERN_ANN_DT_AND_PER |  | Ticker/Month/Year | Month | Day | Year
ALK02/04/10 | ALK | 02/04/10 | ALK22010 | 2 | 4 | 2010 |  |  |  |  |  | #N/A | 2009:A
CAL02/04/10 | CAL | 02/04/10 | CAL22010 | 2 | 4 | 2010 |  |  |  |  |  | 2010-01-28 00:00:00 | 2009:Q4 | ALK12010 | 1 | 10 | 2010
DAL02/04/10 | DAL | 02/04/10 | DAL22010 | 2 | 4 | 2010 |  |  |  |  |  | 2009-10-22 00:00:00 | 2009:Q3 | ALK102009 | 10 | 22 | 2009
LCC02/04/10 | LCC | 02/04/10 | [NAME] | 2 | 4 | 2010 |  |  |  |  |  | 2009-08-07 00:00:00 | 2009:Q2 | ALK82009 | 8 | 7 | 2009
GOL11/09/09 | GOL | 11/09/09 | GOL112009 | 11 | 9 | 2009 |  |  |  |  |  | 2009-04-23 00:00:00 | 2009:Q1 | ALK42009 | 4 | 23 | 2009
TAM11/09/09 | TAM | 11/09/09 | TAM112009 | 11 | 9 | 2009 |  |  |  |  |  | 2009-01-29 00:00:00 | 2008:A | ALK12009 | 1 | 29 | 2009
AAI10/19/09 | AAI | 10/19/09 | AAI102009 | 10 | 19 | 2009 |  |  |  |  |  | 2009-01-29 00:00:00 | 2008:Q4 | ALK12009 | 1 | 29 | 2009
LUV10/19/09 | LUV | 10/19/09 | LUV102009 | 10 | 19 | 2009 |  |  |  |  |  | 2008-10-23 00:00:00 | 2008:Q3 | ALK102008 | 10 | 23 | 2008
AAI09/10/09 | AAI | 09/10/09 | AAI92009 | 9 | 10 | 2009 |  |  |  |  |  | 2008-07-24 00:00:00 | 2008:Q2 | ALK72008 | 7 | 24 | 2008
[NAME] | [NAME] | 09/10/09 | [NAME] | 9 | 10 | 2009 |  |  |  |  |  | 2008-04-24 00:00:00 | 2008:Q1 | ALK42008 | 4 | 24 | 2008
LCC09/10/09 | LCC | 09/10/09 | LCC92009 | 9 | 10 | 2009 |  |  |  |  |  | 2008-01-24 00:00:00 | 2007:A | ALK12008 | 1 | 24 | 2008
UAUA09/10/09 | UAUA | 09/10/09 | UAUA92009 | 9 | 10 | 2009 |  |  |  |  |  | 2008-01-24 00:00:00 | 2007:Q4 | ALK12008 | 1 | 24 | 2008
CPA07/30/09 | CPA | 07/30/09 | CPA72009 | 7 | 30 | 2009 |  |  |  |  |  | 2007-10-25 00:00:00 | 2007:Q3 | ALK102007 | 10 | 25 | 2007
UAUA06/05/09 | UAUA | 06/05/09 | UAUA62009 | 6 | 5 | 2009 |  |  |  |  |  | 2007-07-26 00:00:00 | 2007:Q2 | ALK72007 | 7 | 26 | 2007
CAL06/02/09 | CAL | 06/02/09 | CAL62009 | 6 | 2 | 2009 |  |  |  |  |  | 2007-04-26 00:00:00 | 2007:Q1 | ALK42007 | 4 | 26 | 2007
CAL04/22/09 | CAL | 04/22/09 | CAL42009 | 4 | 22 | 2009 |  |  |  |  |  | 2007-01-25 00:00:00 | 2006:A | ALK12007 | 1 | 25 | 2007
LCC04/22/09 | LCC | 04/22/09 | LCC42009 | 4 | 22 | 2009 |  |  |  |  |  | 2007-01-25 00:00:00 | 2006:Q4 | ALK12007 | 1 | 25 | 2007
LUV04/22/09 | LUV | 04/22/09 | LUV42009 | 4 | 22 | 2009 |  |  |  |  |  | 2006-10-24 00:00:00 | 2006:Q3 | ALK102006 | 10 | 24 | 2006
UAUA04/22/09 | UAUA | 04/22/09 | UAUA42009 | 4 | 22 | 2009 |  |  |  |  |  | 2006-07-25 00:00:00 | 2006:Q2 | ALK72006 | 7 | 25 | 2006
GOL04/03/09 | GOL | 04/03/09 | GOL42009 | 4 | 3 | 2009 |  |  |  |  |  | 2006-04-20 00:00:00 | 2006:Q1 | ALK42006 | 4 | 20 | 2006
DAL12/12/08 | DAL | 12/12/08 | DAL122008 | 12 | 12 | 2008 |  |  |  |  |  | 2006-01-26 00:00:00 | 2005:A | ALK12006 | 1 | 26 | 2006
DAL11/17/08 | DAL | 11/17/08 | DAL112008 | 11 | 17 | 2008 |  |  |  |  |  | 2006-01-26 00:00:00 | 2005:Q4 | ALK12006 | 1 | 26 | 2006
AER10/28/08 | AER | 10/28/08 | AER102008 | 10 | 28 | 2008 |  |  |  |  |  | 2005-10-20 00:00:00 | 2005:Q3 | ALK102005 | 10 | 20 | 2005
JBLU10/23/08 | [NAME] | 10/23/08 | JBLU102008 | 10 | 23 | 2008 |  |  |  |  |  | 2005-07-21 00:00:00 | 2005:Q2 | ALK72005 | 7 | 21 | 2005
GOL09/12/08 | GOL | 09/12/08 | [NAME] | 9 | 12 | 2008 |  |  |  |  |  | 2005-04-21 00:00:00 | 2005:Q1 | ALK42005 | 4 | 21 | 2005
ALK08/12/08 | ALK | 08/12/08 | ALK82008 | 8 | 12 | 2008 |  |  |  |  |  | 2005-01-28 00:00:00 | 2004:A | ALK12005 | 1 | 28 | 2005
AMR08/12/08 | AMR | 08/12/08 | AMR82008 | 8 | 12 | 2008 |  |  |  |  |  | 2005-01-28 00:00:00 | 2004:Q4 | ALK12005 | 1 | 28 | 2005
CAL08/12/08 | CAL | 08/12/08 | CAL82008 | 8 | 12 | 2008 |  |  |  |  |  | 2004-10-21 00:00:00 | 2004:Q3 | ALK102004 | 10 | 21 | 2004
DAL08/12/08 | DAL | 08/12/08 | DAL82008 | 8 | 12 | 2008 |  |  |  |  |  | 2004-07-22 00:00:00 | 2004:Q2 | ALK72004 | 7 | 22 | 2004
LCC08/12/08 | LCC | 08/12/08 | LCC82008 | 8 | 12 | 2008 |  |  |  |  |  | 2004-04-23 00:00:00 | 2004:Q1 | ALK42004 | 4 | 23 | 2004
LUV08/12/08 | LUV | 08/12/08 | LUV82008 | 8 | 12 | 2008 |  |  |  |  |  | 2004-01-28 00:00:00 | 2003:A | ALK12004 | 1 | 28 | 2004
GOL08/01/08 | GOL | 08/01/08 | GOL82008 | 8 | 1 | 2008 |  |  |  |  |  | 2004-01-28 00:00:00 | 2003:Q4 | ALK12004 | 1 | 28 | 2004
UAUA07/18/08 | UAUA | 07/18/08 | UAUA72008 | 7 | 18 | 2008 |  |  |  |  |  | 2003-10-21 00:00:00 | 2003:Q3 | ALK102003 | 10 | 21 | 2003
ALK05/19/08 | ALK | 05/19/08 | ALK52008 | 5 | 19 | 2008 |  |  |  |  |  | 2003-07-22 00:00:00 | 2003:Q2 | ALK72003 | 7 | 22 | 2003
CAL05/19/08 | CAL | 05/19/08 | CAL52008 | 5 | 19 | 2008 |  |  |  |  |  | 2003-04-22 00:00:00 | 2003:Q1 | ALK42003 | 4 | 22 | 2003
JBLU05/19/08 | [NAME] | 05/19/08 | JBLU52008 | 5 | 19 | 2008 |  |  |  |  |  | 2003-01-30 00:00:00 | 2002:A | ALK12003 | 1 | 30 | 2003
AYR03/26/08 | AYR | 03/26/08 | AYR32008 | 3 | 26 | 2008 |  |  |  |  |  | 2003-01-30 00:00:00 | 2002:Q4 | ALK12003 | 1 | 30 | 2003
GLS03/26/08 | GLS | 03/26/08 | GLS32008 | 3 | 26 | 2008 |  |  |  |  |  | 2002-10-23 00:00:00 | 2002:Q3 | ALK102002 | 10 | 23 | 2002
ALK03/12/08 | ALK | 03/12/08 | ALK32008 | 3 | 12 | 2008 |  |  |  |  |  | 2002-07-22 00:00:00 | 2002:Q2 | ALK72002 | 7 | 22 | 2002
AMR03/12/08 | AMR | 03/12/08 | AMR32008 | 3 | 12 | 2008 |  |  |  |  |  | 2002-04-19 00:00:00 | 2002:Q1 | ALK42002 | 4 | 19 | 2002
CAL03/12/08 | CAL | 03/12/08 | CAL32008 | 3 | 12 | 2008 |  |  |  |  |  | 2002-01-25 00:00:00 | 2001:A | ALK12002 | 1 | 25 | 2002
DAL03/12/08 | DAL | 03/12/08 | DAL32008 | 3 | 12 | 2008 |  |  |  |  |  | 2002-01-25 00:00:00 | 2001:Q4 | ALK12002 | 1 | 25 | 2002
LCC03/12/08 | LCC | 03/12/08 | LCC32008 | 3 | 12 | 2008 |  |  |  |  |  | 2001-10-18 00:00:00 | 2001:Q3 | ALK102001 | 10 | 18 | 2001
UAUA03/12/08 | UAUA | 03/12/08 | UAUA32008 | 3 | 12 | 2008 |  |  |  |  |  | 2001-07-19 00:00:00 | 2001:Q2 | ALK72001 | 7 | 19 | 2001
AAI01/25/08 | AAI | 01/25/08 | AAI12008 | 1 | 25 | 2008 |  |  |  |  |  | 2001-04-19 00:00:00 | 2001:Q1 | ALK42001 | 4 | 19 | 2001
UAUA01/10/08 | UAUA | 01/10/08 | UAUA12008 | 1 | 10 | 2008 |  |  |  |  |  | 2001-01-26 00:00:00 | 2000:A | ALK12001 | 1 | 26 | 2001
UAUA10/25/07 | UAUA | 10/25/07 | UAUA102007 | 10 | 25 | 2007 |  |  |  |  |  | 2001-01-26 00:00:00 | 2000:Q4 | ALK12001 | 1 | 26 | 2001
AAI10/23/07 | AAI | 10/23/07 | AAI102007 | 10 | 23 | 2007 |  |  |  |  |  | 2000-10-17 00:00:00 | 2000:Q3 | [NAME] | 10 | 17 | 2000
GOL09/25/07 | GOL | 09/25/07 | GOL92007 | 9 | 25 | 2007 |  |  |  |  |  | 2000-07-21 00:00:00 | 2000:Q2 | ALK72000 | 7 | 21 | 2000
TAM09/25/07 | TAM | 09/25/07 | TAM92007 | 9 | 25 | 2007 |  |  |  |  |  | 2000-05-10 00:00:00 | 2000:Q1 | ALK52000 | 5 | 10 | 2000
ALK07/27/07 | ALK | 07/27/07 | ALK72007 | 7 | 27 | 2007 | 26 |  |  |  |  | 2000-01-26 00:00:00 | 1999:A | ALK12000 | 1 | 26 | 2000
CPA07/17/07 | CPA | 07/17/07 | CPA72007 | 7 | 17 | 2007 |  |  |  |  |  | 2000-01-26 00:00:00 | 1999:Q4 | ALK12000 | 1 | 26 | 2000
ALK06/28/07 | ALK | 06/28/07 | ALK62007 | 6 | 28 | 2007 |  |  |  |  |  | 1999-10-21 00:00:00 | 1999:Q3 | ALK101999 | 10 | 21 | 1999
AMR06/28/07 | AMR | 06/28/07 | AMR62007 | 6 | 28 | 2007 |  |  |  |  |  | 1999-07-19 00:00:00 | 1999:Q2 | ALK71999 | 7 | 19 | 1999
CAL06/28/07 | CAL | 06/28/07 | CAL62007 | 6 | 28 | 2007 |  |  |  |  |  | 1999-04-19 00:00:00 | 1999:Q1 | ALK41999 | 4 | 19 | 1999
LCC06/28/07 | LCC | 06/28/07 | LCC62007 | 6 | 28 | 2007 |  |  |  |  |  | 1999-01-27 00:00:00 | 1998:A | ALK11999 | 1 | 27 | 1999
LUV06/28/07 | LUV | 06/28/07 | [NAME] | 6 | 28 | 2007 |  |  |  |  |  | 1999-01-27 00:00:00 | 1998:Q4 | ALK11999 | 1 | 27 | 1999
UAUA06/28/07 | UAUA | 06/28/07 | UAUA62007 | 6 | 28 | 2007 |  |  |  |  |  | 1998-10-26 00:00:00 | 1998:Q3 | ALK101998 | 10 | 26 | 1998
ALK04/27/07 | ALK | 04/27/07 | ALK42007 | 4 | 27 | 2007 | 26 | Yes |  |  |  | 1998-07-23 00:00:00 | 1998:Q2 | ALK71998 | 7 | 23 | 1998
AMR04/27/07 | AMR | 04/27/07 | AMR42007 | 4 | 27 | 2007 |  |  |  |  |  | 1998-04-23 00:00:00 | 1998:Q1 | ALK41998 | 4 | 23 | 1998
CAL04/27/07 | CAL | 04/27/07 | CAL42007 | 4 | 27 | 2007 |  |  |  |  |  | 1998-01-28 00:00:00 | 1997:A | ALK11998 | 1 | 28 | 1998
JBLU04/27/07 | [NAME] | 04/27/07 | JBLU42007 | 4 | 27 | 2007 |  |  |  |  |  | 1998-01-28 00:00:00 | 1997:Q4 | ALK11998 | 1 | 28 | 1998
LCC04/27/07 | LCC | 04/27/07 | LCC42007 | 4 | 27 | 2007 |  |  |  |  |  | 1997-10-23 00:00:00 | 1997:Q3 | ALK101997 | 10 | 23 | 1997
UAUA04/27/07 | UAUA | 04/27/07 | UAUA42007 | 4 | 27 | 2007 |  |  |  |  |  | 1997-07-21 00:00:00 | 1997:Q2 | ALK71997 | 7 | 21 | 1997
LUV04/19/07 | LUV | 04/19/07 | LUV42007 | 4 | 19 | 2007 |  |  |  |  |  | 1997-04-21 00:00:00 | 1997:Q1 | [NAME] | 4 | 21 | 1997
AAI03/21/07 | AAI | 03/21/07 | [NAME] | 3 | 21 | 2007 |  |  |  |  |  | 1997-01-28 00:00:00 | 1996:A | ALK11997 | 1 | 28 | 1997
CAL03/15/07 | CAL | 03/15/07 | CAL32007 | 3 | 15 | 2007 |  |  |  |  |  | 1997-01-28 00:00:00 | 1996:Q4 | ALK11997 | 1 | 28 | 1997
CAL01/24/07 | CAL | 01/24/07 | CAL12007 | 1 | 24 | 2007 |  |  |  |  |  | 1996-10-24 00:00:00 | 1996:Q3 | ALK101996 | 10 | 24 | 1996
CPA12/01/06 | CPA | 12/01/06 | CPA122006 | 12 | 1 | 2006 |  |  |  |  |  | 1996-07-18 00:00:00 | 1996:Q2 | ALK71996 | 7 | 18 | 1996
GOL12/01/06 | GOL | 12/01/06 | GOL122006 | 12 | 1 | 2006 |  |  |  |  |  | 1996-04-22 00:00:00 | 1996:Q1 | ALK41996 | 4 | 22 | 1996
TAM12/01/06 | TAM | 12/01/06 | TAM122006 | 12 | 1 | 2006 |  |  |  |  |  | 1996-01-26 00:00:00 | 1995:A | [NAME] | 1 | 26 | 1996
JBLU10/25/06 | [NAME] | 10/25/06 | JBLU102006 | 10 | 25 | 2006 |  |  |  |  |  | 1996-01-26 00:00:00 | 1995:Q4 | [NAME] | 1 | 26 | 1996
CPA10/24/06 | CPA | 10/24/06 | CPA102006 | 10 | 24 | 2006 |  |  |  |  |  | 1995-10-18 00:00:00 | 1995:Q3 | ALK101995 | 10 | 18 | 1995
GOL10/24/06 | GOL | 10/24/06 | GOL102006 | 10 | 24 | 2006 |  |  |  |  |  | 1995-07-21 00:00:00 | 1995:Q2 | ALK71995 | 7 | 21 | 1995
TAM10/24/06 | TAM | 10/24/06 | TAM102006 | 10 | 24 | 2006 |  |  |  |  |  | 1995-04-14 00:00:00 | 1995:Q1 | [NAME] | 4 | 14 | 1995
ALK05/02/06 | ALK | 05/02/06 | ALK52006 | 5 | 2 | 2006 |  |  |  |  |  | 1995-01-30 00:00:00 | 1994:A | ALK11995 | 1 | 30 | 1995
JBLU05/02/06 | [NAME] | 05/02/06 | JBLU52006 | 5 | 2 | 2006 |  |  |  |  |  | 1995-01-30 00:00:00 | 1994:Q4 | ALK11995 | 1 | 30 | 1995
LUV05/02/06 | LUV | 05/02/06 | LUV52006 | 5 | 2 | 2006 |  |  |  |  |  | 1994-10-19 00:00:00 | 1994:Q3 | ALK101994 | 10 | 19 | 1994
JBLU02/24/06 | [NAME] | 02/24/06 | JBLU22006 | 2 | 24 | 2006 |  |  |  |  |  | 1994-07-19 00:00:00 | 1994:Q2 | ALK71994 | 7 | 19 | 1994
ALK01/27/06 | ALK | 01/27/06 | ALK12006 | 1 | 27 | 2006 | 26 | Yes |  |  |  | 1994-04-19 00:00:00 | 1994:Q1 | ALK41994 | 4 | 19 | 1994
 |  |  |  |  |  |  |  |  |  |  |  | 1994-01-27 00:00:00 | 1993:A | ALK11994 | 1 | 27 | 1994
 |  |  |  |  |  |  |  |  |  |  |  | 1994-01-27 00:00:00 | 1993:Q4 | ALK11994 | 1 | 27 | 1994
 |  |  |  |  |  |  |  |  |  |  |  | 1993-10-21 00:00:00 | 1993:Q3 | ALK101993 | 10 | 21 | 1993
 |  |  |  |  |  |  |  |  |  |  |  | 1993-07-20 00:00:00 | 1993:Q2 | ALK71993 | 7 | 20 | 1993
 |  |  |  |  |  |  |  |  |  |  |  | 1993-04-20 00:00:00 | 1993:Q1 | ALK41993 | 4 | 20 | 1993
 |  |  |  |  |  |  |  |  |  |  |  | N.A. | 1992:A |  | N.A.
 |  |  |  |  |  |  |  |  |  |  |  | N.A. | 1992:Q4 |  | N.A.
 |  |  |  |  |  |  |  |  |  |  |  | N.A. | 1992:Q3 |  | N.A.
 |  |  |  |  |  |  |  |  |  |  |  | N.A. | 1992:Q2 |  | N.A.
 |  |  |  |  |  |  |  |  |  |  |  | N.A. | 1992:Q1 |  | N.A.
 |  |  |  |  |  |  |  |  |  |  |  | N.A. | 1991:A |  | N.A.
 |  |  |  |  |  |  |  |  |  |  |  | N.A. | 1991:Q4 |  | N.A.
 |  |  |  |  |  |  |  |  |  |  |  | N.A. | 1991:Q3 |  | N.A.
 |  |  |  |  |  |  |  |  |  |  |  | N.A. | 1991:Q2 |  | N.A.
 |  |  |  |  |  |  |  |  |  |  |  | N.A. | 1991:Q1 |  | N.A.
 |  |  |  |  |  |  |  |  |  |  |  | N.A. | 1990:A |  | N.A.
 |  |  |  |  |  |  |  |  |  |  |  | N.A. | 1990:Q4 |  | N.A.
 |  |  |  |  |  |  |  |  |  |  |  | N.A. | 1990:Q3 |  | N.A.
 |  |  |  |  |  |  |  |  |  |  |  | N.A. | 1990:Q2 |  | N.A.