Require help with an excel formula

UE Release Date Observation Month UE Rate Observations Days Daily UE data S&P 500 Date S&P 500 Close
5/6/55 4/1/55 4.7 5/6/55   5/6/55 37.889999
6/7/55 5/1/55 4.3 5/9/55   5/9/55 37.93
7/8/55 6/1/55 4.2 5/10/55   5/10/55 37.849998
8/9/55 7/1/55 4.0 5/11/55   5/11/55 37.419998
9/7/55 8/1/55 4.2 5/12/55   5/12/55 37.200001
10/10/55 9/1/55 4.1 5/13/55   5/13/55 37.439999
11/7/55 10/1/55 4.3 5/16/55   5/16/55 37.02
12/7/55 11/1/55 4.2 5/17/55   5/17/55 36.970001
1/9/56 12/1/55 4.2 5/18/55   5/18/55 37.279999
2/7/56 1/1/56 4.0 5/19/55   5/19/55 37.490002
3/9/56 2/1/56 3.9 5/20/55   5/20/55 37.740002
4/9/56 3/1/56 4.2 5/23/55   5/23/55 37.48
5/8/56 4/1/56 4.0 5/24/55   5/24/55 37.459999
6/8/56 5/1/56 4.3 5/25/55   5/25/55 37.599998
7/9/56 6/1/56 4.3 5/26/55   5/26/55 37.849998
8/8/56 7/1/56 4.4 5/27/55   5/27/55 37.93
9/10/56 8/1/56 4.1 5/31/55   5/31/55 37.91
10/9/56 9/1/56 3.9 6/1/55   6/1/55 37.959999
11/8/56 10/1/56 3.9 6/2/55   6/2/55 38.009998
12/10/56 11/1/56 4.3 6/3/55   6/3/55 38.369999
1/11/57 12/1/56 4.2 6/6/55   6/6/55 39.689999
2/8/57 1/1/57 4.2 6/7/55   6/7/55 39.959999
3/12/57 2/1/57 3.9 6/8/55   6/8/55 39.220001
4/9/57 3/1/57 3.7 6/9/55   6/9/55 39.009998
5/10/57 4/1/57 3.9 6/10/55   6/10/55 39.25
6/11/57 5/1/57 4.1 6/13/55   6/13/55 39.619999
7/11/57 6/1/57 4.3 6/14/55   6/14/55 39.669998
8/12/57 7/1/57 4.2 6/15/55   6/15/55 39.889999
9/10/57 8/1/57 4.1 6/16/55   6/16/55 39.959999
10/10/57 9/1/57 4.4 6/17/55   6/17/55 40.099998
11/8/57 10/1/57 4.5 6/20/55   6/20/55 40.139999
12/11/57 11/1/57 5.1 6/21/55   6/21/55 40.509998
1/14/58 12/1/57 5.2 6/22/55   6/22/55 40.599998
2/11/58 1/1/58 5.8 6/23/55   6/23/55 40.75
3/11/58 2/1/58 6.4 6/24/55   6/24/55 40.959999
4/8/58 3/1/58 6.7 6/27/55   6/27/55 40.990002
5/8/58 4/1/58 7.4 6/28/55   6/28/55 40.77
6/6/58 5/1/58 7.4 6/29/55   6/29/55 40.790001
7/8/58 6/1/58 7.3 6/30/55   6/30/55 41.029999

By: Kent

Leave a Reply

Your email address will not be published. Required fields are marked *