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

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

Re: Earliest date & time

From isabelle <i@v.invalid>
Newsgroups microsoft.public.excel.programming
Subject Re: Earliest date & time
Date 2016-10-26 20:04 -0400
Organization Aioe.org NNTP Server
Message-ID <nurga7$17ms$1@gioia.aioe.org> (permalink)
References <66bdd866-f844-489f-b30c-daf1794ac287@googlegroups.com> <XnsA6AB4B318505Dauricauricauricauric@213.239.209.88> <f74c855e-7324-4004-b15e-4015c24ca8a9@googlegroups.com>

Show all headers | View raw

=IF(E1=A1+B1,ADDRESS(ROW(),1,4)&":"&ADDRESS(ROW(),2,4),IF(E1=C1+D1,ADDRESS(ROW(),3,4)&":"&ADDRESS(ROW(),4,4),""))

isabelle

Le 2016-10-26 à 19:54, GARYWC a écrit :
> The dates and times are still in A1/B1 and in C1/D1 and the serial number is in E1.
>
> Which date and time does the serial number represent?
>

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