negative dates in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that must have been made from some sort of database.
One of the fields is date of birth. Since Excel does not work with dates
earlier then 1/1/1900 (i'm using 2003) one of the dates is listed as -127. I
am moving this data back into a database ( Access) and need a valid date. I
am assuming that since 1/1/2000 - 127 = 8/27/1999 it would only make since
that 1/1/1900 - 127 = 8/27/1899. Is that how excel determines what neg number
to plug in? Does anyone know how to reverse that neg number to get a date?

Thanks,
Peek
 
I think you may be one off. 1/1/1900 is 1 and 12/31/1899 is 0:

1/1/1900 1.00
12/31/1899 0
12/30/1899 -1
12/29/1899 -2
12/28/1899 -3
12/27/1899 -4
12/26/1899 -5
12/25/1899 -6
12/24/1899 -7
12/23/1899 -8
12/22/1899 -9
12/21/1899 -10
12/20/1899 -11
12/19/1899 -12
12/18/1899 -13
12/17/1899 -14
12/16/1899 -15
12/15/1899 -16
12/14/1899 -17
12/13/1899 -18
12/12/1899 -19
12/11/1899 -20
12/10/1899 -21
12/9/1899 -22
12/8/1899 -23
12/7/1899 -24
12/6/1899 -25
12/5/1899 -26
12/4/1899 -27
12/3/1899 -28
12/2/1899 -29
12/1/1899 -30
11/30/1899 -31
11/29/1899 -32
11/28/1899 -33
11/27/1899 -34
11/26/1899 -35
11/25/1899 -36
11/24/1899 -37
11/23/1899 -38
11/22/1899 -39
11/21/1899 -40
11/20/1899 -41
11/19/1899 -42
11/18/1899 -43
11/17/1899 -44
11/16/1899 -45
11/15/1899 -46
11/14/1899 -47
11/13/1899 -48
11/12/1899 -49
11/11/1899 -50
11/10/1899 -51
11/9/1899 -52
11/8/1899 -53
11/7/1899 -54
11/6/1899 -55
11/5/1899 -56
11/4/1899 -57
11/3/1899 -58
11/2/1899 -59
11/1/1899 -60
10/31/1899 -61
10/30/1899 -62
10/29/1899 -63
10/28/1899 -64
10/27/1899 -65
10/26/1899 -66
10/25/1899 -67
10/24/1899 -68
10/23/1899 -69
10/22/1899 -70
10/21/1899 -71
10/20/1899 -72
10/19/1899 -73
10/18/1899 -74
10/17/1899 -75
10/16/1899 -76
10/15/1899 -77
10/14/1899 -78
10/13/1899 -79
10/12/1899 -80
10/11/1899 -81
10/10/1899 -82
10/9/1899 -83
10/8/1899 -84
10/7/1899 -85
10/6/1899 -86
10/5/1899 -87
10/4/1899 -88
10/3/1899 -89
10/2/1899 -90
10/1/1899 -91
9/30/1899 -92
9/29/1899 -93
9/28/1899 -94
9/27/1899 -95
9/26/1899 -96
9/25/1899 -97
9/24/1899 -98
9/23/1899 -99
9/22/1899 -100
9/21/1899 -101
9/20/1899 -102
9/19/1899 -103
9/18/1899 -104
9/17/1899 -105
9/16/1899 -106
9/15/1899 -107
9/14/1899 -108
9/13/1899 -109
9/12/1899 -110
9/11/1899 -111
9/10/1899 -112
9/9/1899 -113
9/8/1899 -114
9/7/1899 -115
9/6/1899 -116
9/5/1899 -117
9/4/1899 -118
9/3/1899 -119
9/2/1899 -120
9/1/1899 -121
8/31/1899 -122
8/30/1899 -123
8/29/1899 -124
8/28/1899 -125
8/27/1899 -126
8/26/1899 -127
 
Back
Top