Thread: Earliest date & time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
  
Posts: 99
Default Earliest date & time
=IF(E1=A1+B1,ADDRESS(ROW(),1,4)&":"&ADDRESS(ROW(), 2,4),IF(E1=C1+D1,ADDRESS(ROW(),3,4)&":"&ADDRESS(RO W(),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?

Reply With QuoteReply With Quote