Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 80
Default Earliest date & time

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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
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?

  #3   Report Post  
Banned
 
Posts: 3
Default

Lắp đặt, d*n dựng sân khấu chuyên nghiệp -LH 0911 000 222


Đạt Phương - Đơn vị chuyên cung cấp, cho thuê âm thanh - ánh sáng - cung cấp, lắp đặt sân khấu phục vụ sự kiện chuyên nghiệp. ... Chuyên thiết kế, cung cấp v* lắp đặt hệ thống thiết bị âm thanh, ánh sáng, không gian, ...sân khấu. Liên hệ Mr Đạt 0907 150 220



[center]







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Earliest date and time GARYWC Excel Programming 1 October 24th 16 10:37 AM
Earliest time in a range pete Excel Worksheet Functions 3 March 9th 10 09:25 PM
Earliest Date to populate? sonquizzon Excel Worksheet Functions 2 June 16th 05 07:35 PM


All times are GMT +1. The time now is 08:20 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"