Spreadsheet: 841034d1693296072-getting-value-error-with-pre-1900-dates-how-to-overcome-date-formate
Sheet: Sheet1

Date | Value |  |  |  |  |  | 1889
1/1/1889 | 0 |  |  |  |  | 1889
1/2/1889 | 0 |  |  |  |  | 1890
1/3/1889 | 0
1/4/1889 | 0
1/5/1889 | 0
1/6/1889 | 0
1/7/1889 | 0
1/8/1889 | 0
1/9/1889 | 0
1/10/1889 | 0
1/11/1889 | 0
1/12/1889 | 0
1/13/1889 | 0
1/14/1889 | 0
1/15/1889 | 0
1/16/1889 | 0
1/17/1889 | 0
1/18/1889 | 0
1/19/1889 | 0
1/20/1889 | 0
1/21/1889 | 0
1/22/1889 | 0
1/23/1889 | 0
1/24/1889 | 0
1/25/1889 | 0
1/26/1889 | 0
1/27/1889 | 0
1/28/1889 | 0
1/29/1889 | 0
1/30/1889 | 0
1/31/1889 | 0
2/1/1889 | 0
2/2/1889 | 0
2/3/1889 | 0
2/4/1889 | 0
2/5/1889 | 0
2/6/1889 | 0
2/7/1889 | 0
2/8/1889 | 0
2/9/1889 | 0
2/10/1889 | 0
2/11/1889 | 0
2/12/1889 | 0
2/13/1889 | 0
2/14/1889 | 0
2/15/1889 | 0
2/16/1889 | 0
2/17/1889 | 0
2/18/1889 | 0
2/19/1889 | 0
2/20/1889 | 0
2/21/1889 | 0
2/22/1889 | 0
2/23/1889 | 0
2/24/1889 | 0
2/25/1889 | 0
2/26/1889 | 0
2/27/1889 | 0
2/28/1889 | 0
3/1/1889 | 0
3/2/1889 | 0
3/3/1889 | 0
3/4/1889 | 0
3/5/1889 | 0
3/6/1889 | 0
3/7/1889 | 0
3/8/1889 | 0
3/9/1889 | 0
3/10/1889 | 0
3/11/1889 | 0
3/12/1889 | 0
3/13/1889 | 0
3/14/1889 | 0
3/15/1889 | 0
3/16/1889 | 0
3/17/1889 | 0
3/18/1889 | 0
3/19/1889 | 0
3/20/1889 | 0
3/21/1889 | 0
3/22/1889 | 0
3/23/1889 | 0
3/24/1889 | 0
3/25/1889 | 0
3/26/1889 | 0
3/27/1889 | 0
3/28/1889 | 0
3/29/1889 | 0
3/30/1889 | 0
3/31/1889 | 0
4/1/1889 | 0
4/2/1889 | 0
4/3/1889 | 0
4/4/1889 | 0
4/5/1889 | 0
4/6/1889 | 0
4/7/1889 | 0
4/8/1889 | 0
4/9/1889 | 0
4/10/1889 | 0
4/11/1889 | 0
4/12/1889 | 0
4/13/1889 | 0
4/14/1889 | 0
4/15/1889 | 0
4/16/1889 | 0
4/17/1889 | 0
4/18/1889 | 0
4/19/1889 | 0
4/20/1889 | 0
4/21/1889 | 0
4/22/1889 | 0
4/23/1889 | 0
4/24/1889 | 0
4/25/1889 | 0
4/26/1889 | 0
4/27/1889 | 0
4/28/1889 | 0
4/29/1889 | 0
4/30/1889 | 0
5/1/1889 | 0
5/2/1889 | 0
5/3/1889 | 0
5/4/1889 | 0
5/5/1889 | 0
5/6/1889 | 0
5/7/1889 | 0
5/8/1889 | 0
5/9/1889 | 0
5/10/1889 | 0
5/11/1889 | 0
5/12/1889 | 0
5/13/1889 | 0
5/14/1889 | 0
5/15/1889 | 0
5/16/1889 | 0
5/17/1889 | 0
5/18/1889 | 0
5/19/1889 | 0
5/20/1889 | 0
5/21/1889 | 0
5/22/1889 | 0
5/23/1889 | 0
5/24/1889 | 0
5/25/1889 | 0
5/26/1889 | 0
5/27/1889 | 0
5/28/1889 | 0
5/29/1889 | 0
5/30/1889 | 0
5/31/1889 | 0
6/1/1889 | 0
6/2/1889 | 0
6/3/1889 | 0
6/4/1889 | 0
6/5/1889 | 0
6/6/1889 | 0
6/7/1889 | 0
6/8/1889 | 0
6/9/1889 | 0
6/10/1889 | 0
6/11/1889 | 0
6/12/1889 | 0
6/13/1889 | 0
6/14/1889 | 0
6/15/1889 | 0
6/16/1889 | 0
6/17/1889 | 0
6/18/1889 | 0
6/19/1889 | 0
6/20/1889 | 0
6/21/1889 | 0
6/22/1889 | 0
6/23/1889 | 0
6/24/1889 | 0
6/25/1889 | 0
6/26/1889 | 0
6/27/1889 | 0
6/28/1889 | 0
6/29/1889 | 0
6/30/1889 | 0
7/1/1889 | 0
7/2/1889 | 0
7/3/1889 | 0
7/4/1889 | 0
7/5/1889 | 0
7/6/1889 | 0
7/7/1889 | 0
7/8/1889 | 0
7/9/1889 | 0
7/10/1889 | 0
7/11/1889 | 0
7/12/1889 | 0
7/13/1889 | 0
7/14/1889 | 0
7/15/1889 | 0
7/16/1889 | 0
7/17/1889 | 0
7/18/1889 | 0
[NAME] | 0
7/20/1889 | 0
7/21/1889 | 0
7/22/1889 | 0
7/23/1889 | 0
7/24/1889 | 0
7/25/1889 | 0
7/26/1889 | 0
7/27/1889 | 0
7/28/1889 | 0
7/29/1889 | 0
7/30/1889 | 0
7/31/1889 | 0
8/1/1889 | 0
8/2/1889 | 0
8/3/1889 | 0
8/4/1889 | 0
8/5/1889 | 0
8/6/1889 | 0
8/7/1889 | 0
8/8/1889 | 0.00584
8/9/1889 | 0
8/10/1889 | 0
8/11/1889 | 0
8/12/1889 | 0
8/13/1889 | 0
8/14/1889 | 0
[NAME] | 0
8/16/1889 | 0
8/17/1889 | 0
8/18/1889 | 0
8/19/1889 | 0
8/20/1889 | 0
8/21/1889 | 0
8/22/1889 | 0
8/23/1889 | 0
8/24/1889 | 0
8/25/1889 | 0
8/26/1889 | 0
8/27/1889 | 0
8/28/1889 | 0
8/29/1889 | 0
8/30/1889 | 0
8/31/1889 | 0.02887
9/1/1889 | 0.01605
9/2/1889 | 0
9/3/1889 | 0
9/4/1889 | 0
9/5/1889 | 0
9/6/1889 | 0
9/7/1889 | 0
9/8/1889 | 0
9/9/1889 | 0
9/10/1889 | 0
9/11/1889 | 0
[NAME] | 0
9/13/1889 | 0
9/14/1889 | 0
9/15/1889 | 0
9/16/1889 | 0
9/17/1889 | 0
9/18/1889 | 0
[NAME] | 0
9/20/1889 | 0
9/21/1889 | 0
9/22/1889 | 0
9/23/1889 | 0
9/24/1889 | 0
9/25/1889 | 0
9/26/1889 | 0
9/27/1889 | 0
9/28/1889 | 0
9/29/1889 | 0
9/30/1889 | 0
10/1/1889 | 0
10/2/1889 | 0
10/3/1889 | 0
10/4/1889 | 0
10/5/1889 | 0
10/6/1889 | 0
10/7/1889 | 0
10/8/1889 | 0
10/9/1889 | 0
10/10/1889 | 0
10/11/1889 | 0
10/12/1889 | 0
10/13/1889 | 0
10/14/1889 | 0
[NAME] | 0
10/16/1889 | 0
10/17/1889 | 0.01622
10/18/1889 | 0.01158
10/19/1889 | 0
10/20/1889 | 0
10/21/1889 | 0
10/22/1889 | 0
10/23/1889 | 0
10/24/1889 | 0
10/25/1889 | 0
10/26/1889 | 0
10/27/1889 | 0
10/28/1889 | 0
10/29/1889 | 0
10/30/1889 | 0
10/31/1889 | 0
11/1/1889 | 0
11/2/1889 | 0
11/3/1889 | 0
11/4/1889 | 0
11/5/1889 | 0
11/6/1889 | 0
11/7/1889 | 0
11/8/1889 | 0
11/9/1889 | 0
11/10/1889 | 0
11/11/1889 | 0.01803
11/12/1889 | 0
11/13/1889 | 0
11/14/1889 | 0
11/15/1889 | 0
11/16/1889 | 0
11/17/1889 | 0
11/18/1889 | 0
11/19/1889 | 0
11/20/1889 | 0
11/21/1889 | 0
11/22/1889 | 0
11/23/1889 | 0
11/24/1889 | 0
11/25/1889 | 0
11/26/1889 | 0
11/27/1889 | 0
11/28/1889 | 0
11/29/1889 | 0
11/30/1889 | 0
12/1/1889 | 0
12/2/1889 | 0
12/3/1889 | 0
12/4/1889 | 0
12/5/1889 | 0
12/6/1889 | 0
12/7/1889 | 0
12/8/1889 | 0
12/9/1889 | 0
12/10/1889 | 0
12/11/1889 | 0
12/12/1889 | 0
12/13/1889 | 0
12/14/1889 | 0
12/15/1889 | 0
12/16/1889 | 0
12/17/1889 | 0
12/18/1889 | 0
12/19/1889 | 0
12/20/1889 | 0
12/21/1889 | 0
12/22/1889 | 0
12/23/1889 | 0
12/24/1889 | 0
12/25/1889 | 0
12/26/1889 | 0
12/27/1889 | 0
12/28/1889 | 0
12/29/1889 | 0
12/30/1889 | 0
12/31/1889 | 0
1/1/1890 | 0
1/2/1890 | 0
1/3/1890 | 0
1/4/1890 | 0
1/5/1890 | 0
1/6/1890 | 0
1/7/1890 | 0
1/8/1890 | 0
1/9/1890 | 0
1/10/1890 | 0
1/11/1890 | 0
1/12/1890 | 0
1/13/1890 | 0
1/14/1890 | 0
1/15/1890 | 0
1/16/1890 | 0
1/17/1890 | 0
1/18/1890 | 0
1/19/1890 | 0
1/20/1890 | 0
1/21/1890 | 0
1/22/1890 | 0
1/23/1890 | 0.02466
1/24/1890 | 0
1/25/1890 | 0
1/26/1890 | 1.496
1/27/1890 | 1.599
1/28/1890 | 1.564
1/29/1890 | 1.686
1/30/1890 | 1.693
1/31/1890 | 1.645
2/1/1890 | 1.602
2/2/1890 | 1.566
2/3/1890 | 1.525
2/4/1890 | 1.484
2/5/1890 | 1.444
2/6/1890 | 1.589
2/7/1890 | 1.584
2/8/1890 | 1.567
2/9/1890 | 1.526
2/10/1890 | 1.505
2/11/1890 | 1.464
2/12/1890 | 1.423
2/13/1890 | 1.382
2/14/1890 | 1.342
2/15/1890 | 1.301
2/16/1890 | 1.26
2/17/1890 | 1.22
2/18/1890 | 1.179
2/19/1890 | 1.138
2/20/1890 | 1.098
2/21/1890 | 1.057
2/22/1890 | 1.017
2/23/1890 | 0.9765
2/24/1890 | 0.9361
2/25/1890 | 0.8958
2/26/1890 | 0.8554
2/27/1890 | 0.8151
2/28/1890 | 0.7749
3/1/1890 | 0.7347
3/2/1890 | 0.6997
3/3/1890 | 0.6648
3/4/1890 | 0.6298
3/5/1890 | 0.5949
3/6/1890 | 0.5601
3/7/1890 | 0.5252
3/8/1890 | 0.4904
3/9/1890 | 0.4556
3/10/1890 | 0.4209
3/11/1890 | 0.3861
3/12/1890 | 0.3514
3/13/1890 | 0.3167
3/14/1890 | 0.2821
3/15/1890 | 0.2475
3/16/1890 | 0.2129
3/17/1890 | 0.1783
3/18/1890 | 0.1438
3/19/1890 | 0.1092
3/20/1890 | 0.07475
3/21/1890 | 0.04029
3/22/1890 | 0.00585
3/23/1890 | 0
3/24/1890 | 0
3/25/1890 | 0
3/26/1890 | 0
3/27/1890 | 0
3/28/1890 | 0
3/29/1890 | 0
3/30/1890 | 0
3/31/1890 | 0
4/1/1890 | 0
4/2/1890 | 0
4/3/1890 | 0
4/4/1890 | 0
4/5/1890 | 0
4/6/1890 | 0
4/7/1890 | 0
4/8/1890 | 0
4/9/1890 | 0.006292
4/10/1890 | 0
4/11/1890 | 0.0008085
4/12/1890 | 0
4/13/1890 | 0
4/14/1890 | 0
4/15/1890 | 0
4/16/1890 | 0
4/17/1890 | 0
4/18/1890 | 0
4/19/1890 | 0
4/20/1890 | 0
4/21/1890 | 0
4/22/1890 | 0
4/23/1890 | 0
4/24/1890 | 0
4/25/1890 | 0
4/26/1890 | 0
4/27/1890 | 0.01178
4/28/1890 | 0
4/29/1890 | 0
4/30/1890 | 0
5/1/1890 | 0
5/2/1890 | 0
5/3/1890 | 0
5/4/1890 | 0
5/5/1890 | 0
5/6/1890 | 0
5/7/1890 | 0
5/8/1890 | 0
5/9/1890 | 0
5/10/1890 | 0
5/11/1890 | 0
5/12/1890 | 0
5/13/1890 | 0
5/14/1890 | 0
5/15/1890 | 0
5/16/1890 | 0.03757
5/17/1890 | 0.02577
5/18/1890 | 0.01726
5/19/1890 | 0.003277
5/20/1890 | 0
5/21/1890 | 0
5/22/1890 | 0.03537
5/23/1890 | 0.02138
5/24/1890 | 0.158
5/25/1890 | 0.1506
5/26/1890 | 0.1372
5/27/1890 | 0.1232
5/28/1890 | 0.1092
5/29/1890 | 0.1106
5/30/1890 | 0.09655
5/31/1890 | 0.08254
6/1/1890 | 0.07621
6/2/1890 | 0.06644
6/3/1890 | 0.05775
6/4/1890 | 0.04798
6/5/1890 | 0.03821
6/6/1890 | 0.02844
6/7/1890 | 0.01867
6/8/1890 | 0.0089
6/9/1890 | 0
6/10/1890 | 0
6/11/1890 | 0.007785
6/12/1890 | 0
6/13/1890 | 0
6/14/1890 | 0
6/15/1890 | 0
6/16/1890 | 0.003398
6/17/1890 | 0
6/18/1890 | 0.01875
6/19/1890 | 0.03969
6/20/1890 | 0.03431
6/21/1890 | 0.1324
6/22/1890 | 0.2027
6/23/1890 | 0.3901
6/24/1890 | 0.3955
6/25/1890 | 0.3871
6/26/1890 | 0.3774
6/27/1890 | 0.3676
6/28/1890 | 0.3698
6/29/1890 | 0.36
6/30/1890 | 0.3502
7/1/1890 | 0.3403
7/2/1890 | 0.3497
7/3/1890 | 0.3447
7/4/1890 | 0.3332
7/5/1890 | 0.3305
7/6/1890 | 0.319
[NAME] | 0.3075
7/8/1890 | 0.396
7/9/1890 | 0.3881
7/10/1890 | 0.3792
7/11/1890 | 0.3677
7/12/1890 | 0.3562
[NAME] | 0.3447
7/14/1890 | 0.3332
7/15/1890 | 0.3217
7/16/1890 | 0.3102
7/17/1890 | 0.2987
7/18/1890 | 0.2872
7/19/1890 | 0.2988
7/20/1890 | 0.2873
7/21/1890 | 0.3197
7/22/1890 | 0.3224
7/23/1890 | 0.311
7/24/1890 | 0.3389
7/25/1890 | 0.3274
7/26/1890 | 0.3159
7/27/1890 | 0.3045
7/28/1890 | 0.293
7/29/1890 | 0.2815
7/30/1890 | 0.4486
7/31/1890 | 1.397
8/1/1890 | 1.474
8/2/1890 | 1.484
8/3/1890 | 1.472
8/4/1890 | 1.455
8/5/1890 | 1.437
8/6/1890 | 1.42
8/7/1890 | 1.411
8/8/1890 | 1.395
8/9/1890 | 1.377
8/10/1890 | 1.359
8/11/1890 | 1.342
8/12/1890 | 1.326
8/13/1890 | 1.318
8/14/1890 | 1.301
8/15/1890 | 1.283
8/16/1890 | 1.265
8/17/1890 | 1.248
8/18/1890 | 1.23
8/19/1890 | 1.212
8/20/1890 | 1.195
8/21/1890 | 1.179
8/22/1890 | 1.161
8/23/1890 | 1.144
8/24/1890 | 1.126
8/25/1890 | 1.11
8/26/1890 | 1.095
8/27/1890 | 1.085
8/28/1890 | 1.071
8/29/1890 | 1.053
8/30/1890 | 1.039
8/31/1890 | 1.022
9/1/1890 | 1.004
9/2/1890 | 0.9785
9/3/1890 | 0.953
9/4/1890 | 0.9276
9/5/1890 | 0.9022
9/6/1890 | 0.8768
9/7/1890 | 0.8634
9/8/1890 | 0.8381
9/9/1890 | 0.8127
9/10/1890 | 0.7873
9/11/1890 | 0.7686
9/12/1890 | 0.7454
9/13/1890 | 0.7201
9/14/1890 | 0.6981
9/15/1890 | 0.6728
9/16/1890 | 0.6475
9/17/1890 | 0.6223
9/18/1890 | 0.597
9/19/1890 | 0.5718
9/20/1890 | 0.5465
9/21/1890 | 0.5213
9/22/1890 | 0.4961
9/23/1890 | 0.471
9/24/1890 | 0.4458
9/25/1890 | 0.4206
9/26/1890 | 0.3955
9/27/1890 | 0.3704
9/28/1890 | 0.3453
9/29/1890 | 0.3202
9/30/1890 | 0.2951
10/1/1890 | 0.27
10/2/1890 | 0.2356
10/3/1890 | 0.2012
10/4/1890 | 0.1668
10/5/1890 | 0.1324
10/6/1890 | 0.0981
10/7/1890 | 0.06379
10/8/1890 | 0.02951
10/9/1890 | 0
10/10/1890 | 0
10/11/1890 | 0
10/12/1890 | 0
10/13/1890 | 0
10/14/1890 | 0
10/15/1890 | 0
10/16/1890 | 0
10/17/1890 | 0
10/18/1890 | 0
10/19/1890 | 0
10/20/1890 | 0
10/21/1890 | 0
10/22/1890 | 0
10/23/1890 | 0
10/24/1890 | 0
10/25/1890 | 0
10/26/1890 | 0
10/27/1890 | 0
10/28/1890 | 0
10/29/1890 | 0
10/30/1890 | 0.05021
10/31/1890 | 0.0291
11/1/1890 | 3.553e-18
11/2/1890 | 0
11/3/1890 | 0
11/4/1890 | 0
11/5/1890 | 0
11/6/1890 | 0
11/7/1890 | 0
11/8/1890 | 0
11/9/1890 | 0
11/10/1890 | 0
11/11/1890 | 0
11/12/1890 | 0
11/13/1890 | 0
11/14/1890 | 0
11/15/1890 | 0
11/16/1890 | 0
11/17/1890 | 0
11/18/1890 | 0
11/19/1890 | 0
11/20/1890 | 0
11/21/1890 | 0
11/22/1890 | 0
11/23/1890 | 0
11/24/1890 | 0.0004794
11/25/1890 | 0
11/26/1890 | 0
11/27/1890 | 0
11/28/1890 | 0
11/29/1890 | 0
11/30/1890 | 0
12/1/1890 | 0
12/2/1890 | 0
12/3/1890 | 0
12/4/1890 | 0
12/5/1890 | 0
12/6/1890 | 0
12/7/1890 | 0
12/8/1890 | 0
12/9/1890 | 0
12/10/1890 | 0
12/11/1890 | 0
12/12/1890 | 0
12/13/1890 | 0
12/14/1890 | 0
12/15/1890 | 0
12/16/1890 | 0
12/17/1890 | 0
12/18/1890 | 0
12/19/1890 | 0
12/20/1890 | 0
12/21/1890 | 0
12/22/1890 | 0
12/23/1890 | 0
12/24/1890 | 0
12/25/1890 | 0
12/26/1890 | 0
12/27/1890 | 0
12/28/1890 | 0
12/29/1890 | 0
12/30/1890 | 0
12/31/1890 | 0