Spreadsheet: 156036d1337158306-issue-with-date-format-in-excel-2003-dateformat-ii_forum
Sheet: Sheet1

 | Open Time | Date should appear like | Time should appear like | Month day format | today's Date | Ageing (in Days)
 | Looking for ----> | dd/mm/yyyy | 17:10:54 | (=c2) than change format to Month, year | What ever todays date is | (Column F-Column E)
Example: | 2012-04-05 15:17:23 | 2011-08-11 00:00:00 | 18:10:21 | 04-May-2012 not 5-April 2012 | 2012-05-16 00:00:00 | 12
 | 15/05/2012 14:38:35
 | 15/05/2012 14:56:00
 | 15/05/2012 21:31:53
 | 25/01/2012 04:29:11
 | 30/03/2012 11:55:27
 | 20/04/2012 13:36:29
 | 2012-03-05 17:21:11
 | 15/05/2012 18:35:42
 | 14/05/2012 14:18:29
 | 15/05/2012 13:50:11
 | 15/05/2012 15:12:16
 | 21/09/2011 21:21:53
 | 23/03/2012 10:30:49
 | 23/03/2012 12:03:17
 | 16/04/2012 11:33:34
 | 2012-09-05 15:32:51
 | 2012-11-05 18:05:58
 | 14/03/2012
 | 21/03/2012
 | 30/04/2012
 | 15/03/2012 18:12:58
 | 22/03/2012 14:22:10
 | 16/04/2012 09:53:41
 | 30/04/2012 17:04:43
 | 2012-03-05 19:09:17
 | 2012-04-05 16:14:27
 | 2012-08-05 13:01:07
 | 14/05/2012 18:19:56
 | 14/05/2012 19:17:35
 | 2012-02-05 17:34:49
 | 2012-10-05 16:29:57
 | 15/05/2012 23:01:58
 | 2012-12-01 17:04:22
 | 2012-12-01 17:02:41
 | 13/02/2012 16:51:38
 | 13/09/2011 12:47:11
 | 2011-12-10 16:57:21
 | 2011-12-12 19:17:22
 | 2011-12-11 02:19:41
 | 14/12/2011 21:44:12
 | [NAME] 17:35:19
 | 25/11/2011 20:26:17
 | 17/08/2011 14:25:27
 | 2011-12-10 14:58:24
 | 2011-01-12 18:51:19
 | 20/02/2012 16:08:30
 | 18/11/2011 19:36:24
 | 21/11/2011 15:21:24
 | 16/09/2011 13:41:15
 | 2011-06-09 14:53:51
 | 22/09/2011 15:09:56
 | 24/08/2011 15:21:18
 | 24/08/2011 22:00:46
 | 24/11/2011 [NAME]
 | 25/11/2011 13:11:45
 | 19/09/2011 14:22:04
 | 25/11/2011 18:28:43
 | 19/09/2011 20:23:47
 | 27/09/2011 16:23:19
 | 27/09/2011 21:58:54
 | 25/11/2011 13:56:44
 | 31/08/2011 16:37:53
 | 2011-01-09 13:43:10
 | 21/07/2011 13:01:40
 | 14/09/2011 20:40:37
 | 17/06/2011 16:49:14
 | 25/10/2011 15:28:15
 | 2011-01-11 14:11:02
 | 30/11/2011 18:34:26
 | 30/11/2011 19:10:39
 | 2011-01-12 14:25:11
 | 2011-01-12 15:09:40
 | 29/08/2011 15:07:16
 | 2011-01-11 18:08:36
 | 2011-01-11 18:14:40
 | 2011-02-11 13:02:52
 | 2011-01-12 18:56:51
 | 2011-01-12 19:54:13
 | 28/11/2011 20:58:57
 | 2011-02-12 11:57:00
 | 2011-02-11 17:27:09
 | 2011-03-11 17:19:59
 | 2011-02-11 17:44:29
 | 2011-03-11 19:24:09
 | 2011-03-11 20:07:26
 | 2011-02-12 20:02:55
 | 2011-02-12 17:02:19
 | 2011-01-12 17:59:28
 | 2011-05-12 17:21:28
 | 2011-06-09 12:25:52
 | 2011-05-12 22:19:19
 | 2011-07-09 19:56:27
 | 2011-01-09 13:20:08
 | 2011-08-09 15:03:14
 | 2011-07-11 17:51:33
 | 2011-04-11 17:26:11
 | 2011-03-11 19:48:54
 | 2011-04-11 11:25:57
 | 2011-08-11 14:59:20
 | 2011-08-11 13:24:20
 | 2011-07-12 15:37:28
 | 2011-07-12 13:52:57
 | 2011-08-11 21:26:39
 | 2011-08-12 15:12:48
 | 2011-08-11 19:29:08
 | 2011-09-11 16:04:09
 | 2011-10-11 12:53:50
 | 2011-10-10 20:13:06
 | 2011-10-12 01:30:20
 | 2011-10-12 00:01:55
 | 2011-12-12 15:29:14
 | 2012-02-01 19:50:33
 | 2012-09-01 14:09:01
 | 2012-09-01 17:05:48
 | 2012-11-01 19:42:12
 | 2012-12-01 07:45:49
 | 2012-11-01 01:05:12
 | 2011-08-09 20:02:58
 | 13/09/2011 14:50:11
 | 13/10/2011 17:01:10
 | 2011-12-12 18:25:38
 | 13/10/2011 23:30:44
 | 13/10/2011 19:09:24
 | 14/12/2011 14:26:46
 | 15/09/2011 13:22:45
 | 14/11/2011 17:35:18
 | 15/11/2011 16:49:31
 | 16/11/2011 11:41:05
 | 16/12/2011 13:57:42
 | 13/10/2011 19:22:22
 | 16/11/2011 19:44:06
 | 18/11/2011 02:50:41
 | 17/11/2011 [NAME]
 | 18/08/2011 18:16:11
 | 15/09/2011 19:19:59
 | 18/12/2011 19:23:46
 | 15/12/2011 18:05:19
 | 2011-05-12 20:51:04
 | 2011-08-09 20:30:52
 | 19/12/2011 13:14:28
 | 20/09/2011 17:10:36
 | 27/09/2011 09:57:15
 | 20/10/2011 20:07:32
 | 19/08/2011 21:57:35
 | 21/09/2011 12:03:37
 | 21/11/2011 23:34:53
 | 22/11/2011 17:09:42
 | 22/12/2011 20:44:10
 | 21/12/2011 01:37:43
 | 25/01/2012 04:39:45
 | 24/08/2011 16:44:20
 | 23/11/2011 22:27:23
 | 23/11/2011 18:48:38
 | 24/11/2011 15:09:45
 | 24/08/2011 17:33:47
 | 24/10/2011 17:42:40
 | 25/10/2011 11:04:02
 | 25/10/2011 13:01:02
 | 14/10/2011 16:47:05
 | 25/10/2011 16:54:16
 | 16/09/2011 20:30:36
 | 16/09/2011 20:32:46
 | 27/09/2011 16:23:20
 | 26/10/2011 16:47:31
 | 26/10/2011 16:51:13
 | 27/10/2011 17:49:53
 | 28/11/2011 [NAME]
 | 25/11/2011 19:42:04
 | 28/11/2011 14:42:49
 | 27/09/2011 11:30:29
 | 25/11/2011 20:08:52
 | 29/11/2011 16:00:35
 | 30/08/2011 12:50:16
 | 30/11/2011 15:02:41
 | 29/11/2011 [NAME]
 | 28/10/2011 19:46:16
 | 28/10/2011 21:58:54
 | 17/01/2012 14:50:35
 | 25/01/2012 04:29:11
 | 14/02/2012 19:03:34
 | 22/02/2012 12:07:06
 | 23/02/2012 [NAME]
 | 24/02/2012 11:10:43
 | 2012-01-03 16:33:15
 | 2012-05-03 13:33:38
 | 14/03/2012 13:24:26
 | 28/11/2011 15:55:42
 | 2011-01-12 16:32:53
 | 2011-02-12 04:12:02
 | 2011-02-11 17:51:42
 | 2011-03-11 13:39:49
 | 2011-03-11 13:32:29
 | 2011-03-11 14:59:49
 | 2011-02-08 17:21:46
 | 2011-03-11 15:33:57
 | 31/10/2011 15:05:28
 | 2011-03-11 17:58:37
 | 2011-05-12 19:01:36
 | 2011-06-12 13:51:40
 | 2011-11-08 16:21:08
 | 2011-11-10 14:03:33
 | 2011-12-08 11:38:27
 | 2011-09-09 16:54:47
 | 2012-02-02 06:40:49
 | 15/09/2011 12:13:07
 | 16/08/2011 12:44:39
 | 16/08/2011 12:35:28
 | 14/11/2011 17:49:50
 | 17/08/2011 12:05:36
 | 19/07/2011 13:57:38
 | 18/07/2011 13:45:33
 | 19/09/2011 18:02:52
 | 20/09/2011 17:02:58
 | 20/12/2011 18:32:14
 | 21/12/2011 14:45:48
 | 19/08/2011 17:40:22
 | 22/08/2011 15:18:19
 | 22/12/2011 15:43:52
 | 21/09/2011 13:40:08
 | 26/09/2011 14:11:16
 | 27/09/2011 17:35:25
 | 28/06/2011 12:43:34
 | 29/06/2011 14:59:15
 | 29/08/2011 17:18:38
 | 29/11/2011 22:21:27
 | 29/11/2011 [NAME]
 | 28/10/2011 19:50:56
 | 19/01/2012 18:13:02
 | 14/02/2012 23:27:26
 | 2012-06-03 16:37:01
 | 2012-07-03 14:18:43
 | 13/03/2012 20:37:30
 | 14/03/2012 18:12:58
 | 2011-01-07 15:29:55
 | 2011-01-07 16:14:43
 | 29/07/2011 16:13:50
 | 26/10/2011 17:29:46
 | 27/10/2011 15:03:04
 | 2011-01-12 17:35:57
 | 2011-07-11 21:56:55
 | 2011-01-12 11:19:26
 | 2011-02-12 12:09:49
 | 2011-05-09 17:32:06
 | 21/10/2011 22:29:53
 | 2011-11-10 19:16:01
 | 30/11/2011 13:54:09
 | 2011-04-08 13:52:44
 | 2011-04-08 14:06:44
 | 2011-02-11 10:51:58
 | 25/08/2011 17:36:42
 | 2011-03-10 08:19:32
 | 25/10/2011 14:36:28
 | 2011-05-12 16:21:20
 | 2011-05-12 16:03:27
 | 2011-05-12 22:01:19
 | 2011-06-06 17:54:04
 | 29/11/2011 [NAME]
 | 2011-06-12 11:55:26
 | 2011-06-12 17:56:16
 | 2011-07-06 14:39:59
 | 2011-05-08 22:01:55
 | 2011-08-06 21:27:19
 | 2011-08-06 21:42:09
 | 21/07/2011 04:32:41
 | 2011-08-08 18:02:31
 | 2011-08-08 15:18:15
 | 2011-02-09 18:30:04
 | 2011-12-08 13:58:46
 | 2011-01-09 19:37:20
 | 2011-08-12 21:59:20
 | 2011-06-07 20:08:58
 | 2011-05-08 11:18:46
 | 23/08/2011 21:41:38
 | 2011-09-06 19:49:59
 | 2011-05-08 22:08:19
 | 2011-10-08 19:51:20
 | 27/09/2011 14:58:37
 | 2011-10-11 18:38:05
 | 2011-12-08 17:08:28
 | 2011-12-08 17:49:39
 | 2011-08-12 20:12:58
 | 27/01/2012 13:36:34
 | 20/02/2012 13:47:54
 | 2012-04-02 14:27:10
 | 2012-01-03 16:25:41
 | 2012-05-03 16:07:57
 | 2012-04-02 13:19:20
 | 2012-07-02 15:55:57
 | 2012-09-01 19:18:50
 | 2012-10-01 19:27:35
 | 2012-03-02 14:59:44
 | 2012-11-01 21:56:13
 | 14/06/2011 12:24:34
 | 26/05/2011 [NAME]
 | [NAME] 12:48:02
 | 14/06/2011 15:47:21
 | 14/06/2011 15:23:37
 | 13/06/2011 16:43:02
 | 2011-11-09 16:06:56
 | 13/02/2012 18:08:59
 | 14/02/2012 18:52:08
 | 14/06/2011 15:01:12
 | 2011-07-06 18:47:20
 | 14/06/2011 13:16:46
 | 2011-06-06 15:34:31
 | 2011-12-08 14:27:24
 | 2011-12-08 18:47:13
 | 2011-11-08 15:53:22
 | 30/08/2011 19:31:08
 | 2011-05-09 16:04:16
 | 2011-07-09 12:12:18
 | 16/12/2011 12:30:22
 | 2011-08-12 16:09:05
 | 16/12/2011 12:36:46
 | 16/01/2012 21:52:09
 | 17/06/2011 14:57:48
 | 17/06/2011 19:05:49
 | 17/06/2011 19:14:11
 | 17/08/2011 11:38:41
 | 17/08/2011 18:36:26
 | 2011-08-08 16:25:04
 | 16/11/2011 21:02:50
 | 17/05/2011 20:23:26
 | 17/05/2011 22:51:14
 | 17/05/2011 19:03:33
 | 17/08/2011 14:11:41
 | 2011-09-07 21:15:13
 | 22/08/2011 17:38:40
 | 20/06/2011 13:27:37
 | 19/08/2011 11:11:00
 | 31/05/2011 14:43:44
 | 2011-12-12 18:25:21
 | 20/01/2012 12:18:11
 | 14/02/2012 11:07:14
 | 2012-01-02 10:29:34
 | 16/06/2011 21:48:50
 | 20/06/2011 [NAME]
 | 16/06/2011 18:53:27
 | 20/07/2011 13:31:36
 | 20/07/2011 13:37:02
 | 20/09/2011 10:58:40
 | 19/09/2011 21:29:08
 | 31/05/2011 20:04:46
 | 21/12/2011 14:03:53
 | 14/02/2012 12:22:08
 | 16/06/2011 11:33:08
 | 17/06/2011 12:46:31
 | 21/07/2011 16:17:47
 | 21/07/2011 16:34:53
 | 19/08/2011 17:34:18
 | 19/08/2011 17:30:27
 | 20/06/2011 21:30:12
 | 22/06/2011 14:58:43
 | 22/06/2011 19:20:01
 | 22/07/2011 15:10:35
 | 22/07/2011 16:38:30
 | 22/09/2011 20:05:37
 | 19/09/2011 20:58:18
 | 2011-12-12 12:05:13
 | 23/06/2011 19:39:40
 | 23/08/2011 16:42:11
 | 17/08/2011 18:09:11
 | 2011-05-09 14:37:28
 | 14/09/2011 19:33:28
 | 15/09/2011 18:45:09
 | 2011-07-09 14:20:09
 | 22/12/2011 16:35:09
 | 19/07/2011 18:47:12
 | 25/07/2011 14:27:57
 | 22/07/2011 16:17:08
 | 25/07/2011 23:40:26
 | 24/08/2011 22:13:11
 | 2011-12-07 18:58:23
 | 23/09/2011 12:52:52
 | 25/05/2011 14:17:28
 | 26/07/2011 13:36:29
 | 25/08/2011 21:25:49
 | 25/10/2011 21:03:18
 | 25/10/2011 19:46:02
 | 25/01/2012 13:33:21
 | 27/05/2011 15:28:57
 | 25/05/2011 10:29:36
 | 26/05/2011 17:56:35
 | 27/06/2011 11:50:11
 | 27/06/2011 15:39:40
 | 27/06/2011 12:06:15
 | 27/07/2011 11:27:52
 | 28/06/2011 11:43:10
 | 28/06/2011 11:48:32
 | 28/07/2011 21:06:37
 | 25/11/2011 13:46:08
 | 17/01/2012 12:37:30
 | 22/06/2011 12:40:29
 | 27/06/2011 14:03:09
 | 29/08/2011 13:09:43
 | 27/12/2011 21:57:48
 | 29/12/2011 21:05:18
 | 30/06/2011 14:55:15
 | 30/08/2011 17:29:10
 | 30/08/2011 17:35:08
 | 30/08/2011 16:58:46
 | 30/09/2011 13:57:10
 | 29/09/2011 15:58:12
 | 30/11/2011 15:30:35
 | 30/05/2011 22:35:50
 | 21/09/2011 21:21:53
 | 15/02/2012 16:22:48
 | 30/06/2011 19:28:47
 | 2011-01-07 11:50:41
 | 2011-01-08 20:19:02
 | 18/07/2011 14:47:59
 | 21/10/2011 22:14:14
 | 28/06/2011 14:56:48
 | 2011-06-06 17:42:04
 | 16/06/2011 17:56:47
 | 17/10/2011 17:31:19
 | 24/02/2012 16:23:03
 | 2011-12-07 19:20:09
 | 2011-12-07 17:09:53
 | 2011-11-08 20:02:21
 | 2012-11-01 19:13:00
 | 2012-09-02 15:13:31
 | 14/07/2011 16:25:30
 | 14/07/2011 13:56:10
 | 19/07/2011 17:24:56
 | 19/07/2011 17:26:32
 | 19/07/2011 17:40:06
 | 19/07/2011 17:45:49
 | 2011-08-08 13:04:12
 | 19/07/2011 23:33:48
 | 19/07/2011 23:37:02
 | 19/07/2011 19:01:45
 | 21/07/2011 17:25:37
 | 14/06/2011 14:26:15
 | 22/06/2011 12:34:31
 | 2011-08-12 20:09:50
 | 22/07/2011 16:04:06
 | 2011-01-09 13:34:30
 | 14/12/2011 23:25:26
 | 21/06/2011 14:52:36
 | 23/11/2011 15:06:06
 | 26/07/2011 17:41:57
 | 21/06/2011 17:02:56
 | 20/06/2011 13:39:21
 | 20/06/2011 19:35:01
 | 2011-03-09 21:22:24
 | 28/11/2011 16:22:57
 | 23/11/2011 15:03:44
 | 30/01/2012 16:55:29
 | 2012-06-02 11:51:22
 | 2012-01-03 22:09:58
 | 2012-02-03 13:07:46
 | 13/03/2012 11:07:05
 | 2011-01-12 16:24:14
 | 16/06/2011 11:50:44
 | 2011-12-09 14:19:56
 | 2011-12-09 14:30:06
 | 18/07/2011 [NAME]
 | 18/05/2011 18:32:21
 | 18/05/2011 17:12:14
 | 2011-02-06 11:16:08
 | 31/05/2011 17:46:14
 | 2011-03-11 19:50:48
 | 23/08/2011 16:34:27
 | 2011-04-10 11:58:40
 | 20/05/2011 14:54:58
 | 2011-05-12 17:05:53
 | 2011-07-12 16:47:35
 | 13/01/2012 10:37:20
 | 15/11/2011 16:31:46
 | 2012-07-03 16:51:41
 | 2011-08-11 22:51:51
 | 26/12/2011 14:57:24
 | 14/09/2011 09:01:41
 | 18/11/2011 18:38:58