Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109464

Re: Earliest date & time

From isabelle <i@v.invalid>
Newsgroups microsoft.public.excel.programming
Subject Re: Earliest date & time
Date 2016-10-24 16:41 -0400
Organization Aioe.org NNTP Server
Message-ID <nulrli$1m75$1@gioia.aioe.org> (permalink)
References <66bdd866-f844-489f-b30c-daf1794ac287@googlegroups.com> <XnsA6AB4B318505Dauricauricauricauric@213.239.209.88> <69f9666f-ab7f-4044-9fee-5a9adddc95d1@googlegroups.com> <nulqrl$1ksk$1@gioia.aioe.org>

Show all headers | View raw

for versions xl2007+
you can use:
=IFERROR(DATE(LEFT(C2,4),MID(C2,6,2),MID(C2,9,2))+RIGHT(C2,8),"")

isabelle

Le 2016-10-24 à 16:27, isabelle a écrit :
> Hi,
>
> to transform a (text)date  in real date
> =DATE(LEFT(C2,4),MID(C2,6,2),MID(C2,9,2))+RIGHT(C2,8)
>
> isabelle
>
>
> Le 2016-10-24 à 14:12, GARYWC a écrit :
>>  =MIN(C1:E1) returns 0 (zero) for all rows.
>>

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Earliest date & time GARYWC <gcotterl@earthlink.net> - 2016-10-23 21:34 -0700
  Re: Earliest date & time "Auric__" <not.my.real@email.address> - 2016-10-24 14:23 +0000
    Re: Earliest date & time GARYWC <gcotterl@earthlink.net> - 2016-10-24 08:28 -0700
    Re: Earliest date & time GARYWC <gcotterl@earthlink.net> - 2016-10-24 11:12 -0700
      Re: Earliest date & time isabelle <i@v.invalid> - 2016-10-24 16:27 -0400
        Re: Earliest date & time isabelle <i@v.invalid> - 2016-10-24 16:41 -0400
    Re: Earliest date & time GARYWC <gcotterl@earthlink.net> - 2016-10-26 12:15 -0700
      Re: Earliest date & time isabelle <i@v.invalid> - 2016-10-26 18:47 -0400
    Re: Earliest date & time GARYWC <gcotterl@earthlink.net> - 2016-10-26 15:52 -0700
      Re: Earliest date & time isabelle <i@v.invalid> - 2016-10-26 19:34 -0400
        Re: Earliest date & time isabelle <i@v.invalid> - 2016-10-26 19:37 -0400
      Re: Earliest date & time isabelle <i@v.invalid> - 2016-10-26 19:53 -0400
    Re: Earliest date & time GARYWC <gcotterl@earthlink.net> - 2016-10-26 16:54 -0700
      Re: Earliest date & time isabelle <i@v.invalid> - 2016-10-26 20:04 -0400
    Re: Earliest date & time GARYWC <gcotterl@earthlink.net> - 2016-10-26 20:25 -0700
      Re: Earliest date & time isabelle <i@v.invalid> - 2016-10-27 01:12 -0400
  Re: Earliest date & time Bruno Campanini <brunocam@libero.it> - 2016-10-25 03:16 +0200
  Re: Earliest date & time dienmaytrangiaabc <dienmaytrangiaabc@gmail.com> - 2016-10-25 05:15 +0100
  Re: Earliest date & time Claus Busch <claus_busch@t-online.de> - 2016-10-25 13:24 +0200

csiph-web