Spreadsheet: 21737d1209614280-date-formats-incorrect-when-vba-opens-workbook-dates_wrong
Sheet: Todays trades

Trade Id | Version | TradeType | Hedge Document | Status | Trade Id | Status | Counterparty | Currency Code | Nominal | Rate | Value Date | Maturity Date | Ticket Id | ExternalId | Version | Entry Date | User Code | Trader | Book Description | Trade Type | Trade Date | Legal Entity | Broker
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 2008-01-05 00:00:00 |  |  |  | 29/04/2008 01:57 |  |  |  |  | 29/04/2008 12:00
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 2008-12-05 00:00:00 |  |  |  | 29/04/2008 03:22 |  |  |  |  | 29/04/2008 12:00
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 14/05/2008 |  |  |  | 29/04/2008 03:23 |  |  |  |  | 29/04/2008 12:00
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 03:29 |  |  |  |  | 29/04/2008 12:00
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 2008-06-05 00:00:00 |  |  |  | 29/04/2008 04:03 |  |  |  |  | 29/04/2008 12:00
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 09:07 |  |  |  |  | 29/04/2008 09:07
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 09:08 |  |  |  |  | 29/04/2008 09:07
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 09:08 |  |  |  |  | 29/04/2008 09:07
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 09:11 |  |  |  |  | 29/04/2008 09:10
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 09:11 |  |  |  |  | 29/04/2008 09:10
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 09:14 |  |  |  |  | 29/04/2008 09:14
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 09:17 |  |  |  |  | 29/04/2008 09:17
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 09:17 |  |  |  |  | 29/04/2008 09:17
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 2008-06-05 00:00:00 |  |  |  | 29/04/2008 09:24 |  |  |  |  | 29/04/2008 09:24
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 2008-06-05 00:00:00 |  |  |  | 29/04/2008 09:26 |  |  |  |  | 29/04/2008 09:24
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 2008-05-05 00:00:00 |  |  |  | 29/04/2008 09:27 |  |  |  |  | 29/04/2008 09:26
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 09:33 |  |  |  |  | 29/04/2008 09:32
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 2008-09-05 00:00:00 |  |  |  | 29/04/2008 09:34 |  |  |  |  | 29/04/2008 09:33
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 2008-02-05 00:00:00 |  |  |  | 29/04/2008 09:45 |  |  |  |  | 29/04/2008 09:43
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 2008-06-05 00:00:00 |  |  |  | 29/04/2008 09:46 |  |  |  |  | 29/04/2008 09:45
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 2008-07-05 00:00:00 |  |  |  | 29/04/2008 09:47 |  |  |  |  | 29/04/2008 09:47
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 10:01 |  |  |  |  | 29/04/2008 10:00
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 30/05/2008 |  |  |  | 29/04/2008 10:02 |  |  |  |  | 29/04/2008 10:01
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 10:03 |  |  |  |  | 29/04/2008 10:02
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 30/05/2008 |  |  |  | 29/04/2008 10:03 |  |  |  |  | 29/04/2008 10:02
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 30/05/2008 |  |  |  | 29/04/2008 10:04 |  |  |  |  | 29/04/2008 10:03
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 2008-06-05 00:00:00 |  |  |  | 29/04/2008 10:06 |  |  |  |  | 29/04/2008 10:06
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 10:13 |  |  |  |  | 29/04/2008 10:13
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 2008-06-05 00:00:00 |  |  |  | 29/04/2008 10:24 |  |  |  |  | 29/04/2008 10:23
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 2008-09-05 00:00:00 |  |  |  | 29/04/2008 10:34 |  |  |  |  | 29/04/2008 10:33
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 2008-08-05 00:00:00 |  |  |  | 29/04/2008 10:45 |  |  |  |  | 29/04/2008 10:44
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 10:46 |  |  |  |  | 29/04/2008 10:45
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 10:46 |  |  |  |  | 29/04/2008 10:46
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 10:47 |  |  |  |  | 29/04/2008 10:46
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 10:47 |  |  |  |  | 29/04/2008 10:47
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 10:52 |  |  |  |  | 29/04/2008 10:52
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 2008-01-05 00:00:00 |  |  |  | 29/04/2008 10:53 |  |  |  |  | 29/04/2008 10:51
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 2008-01-05 00:00:00 |  |  |  | 29/04/2008 10:53 |  |  |  |  | 29/04/2008 10:51
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 2008-06-05 00:00:00 |  |  |  | 29/04/2008 10:55 |  |  |  |  | 29/04/2008 10:55
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 2008-02-05 00:00:00 |  |  |  | 29/04/2008 10:59 |  |  |  |  | 29/04/2008 10:58
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 11:04 |  |  |  |  | 29/04/2008 11:03
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 2008-01-05 00:00:00 |  |  |  | 29/04/2008 11:07 |  |  |  |  | 29/04/2008 11:06
 |  |  |  |  |  |  |  |  |  |  | 2008-05-02 00:00:00 | 16/05/2008 |  |  |  | 29/04/2008 11:07 |  |  |  |  | 29/04/2008 11:06
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 2008-01-05 00:00:00 |  |  |  | 29/04/2008 11:07 |  |  |  |  | 29/04/2008 11:07
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 16/05/2008 |  |  |  | 29/04/2008 11:07 |  |  |  |  | 29/04/2008 11:07
 |  |  |  |  |  |  |  |  |  |  | 29/04/2008 | 30/04/2008 |  |  |  | 29/04/2008 11:11 |  |  |  |  | 29/04/2008 11:11
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 30/05/2008 |  |  |  | 29/04/2008 11:12 |  |  |  |  | 29/04/2008 11:11
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 30/05/2008 |  |  |  | 29/04/2008 11:12 |  |  |  |  | 29/04/2008 11:12
 |  |  |  |  |  |  |  |  |  |  | 30/04/2008 | 2008-01-05 00:00:00 |  |  |  | 29/04/2008 11:24 |  |  |  |  | 29/04/2008 11:23