LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default negative dates in excel

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NEGATIVE DATES IN EXCEL TJV1960 Excel Worksheet Functions 2 February 23rd 07 02:46 AM
negative dates or times are displayed as # # # # Amr Shehata Excel Worksheet Functions 4 February 2nd 07 11:35 AM
negative dates or times are displayed as # # # # Amr Shehata New Users to Excel 3 November 9th 06 12:34 PM
Sumif using dates and positive negative values Eqa Excel Discussion (Misc queries) 1 November 9th 05 09:08 AM
NEGATIVE IN BARCKETS AND UK DATES EASTCOAST Excel Discussion (Misc queries) 2 July 1st 05 01:10 PM


All times are GMT +1. The time now is 08:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"