+ Reply to Thread
Results 1 to 3 of 3

Looking for the longest date from 4 columns

  1. #1
    Registered User
    Join Date
    12-29-2014
    Location
    Indonesia
    MS-Off Ver
    Office 2010,2007
    Posts
    86

    Looking for the longest date from 4 columns

    hi all,

    I am looking for a formula to get the longest date from 4 columns (column "c" up to column "f"). please provide a formula that can be used for this. thank you in advance.

    the example attached.


    regard,

    dolphino
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,063

    Re: Looking for the longest date from 4 columns

    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    but zerro must be hide by format "MM/DD/YYYY;;"

  3. #3
    Registered User
    Join Date
    12-29-2014
    Location
    Indonesia
    MS-Off Ver
    Office 2010,2007
    Posts
    86

    Re: Looking for the longest date from 4 columns

    hi BMV

    thank you for your information. the formula running correctly


    regard,
    dolphino

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Longest streak and current streak if data are placed in two columns
    By Lehoi in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-06-2016, 01:29 AM
  2. [SOLVED] List unique values from 2 columns and find out Longest and Shortest Duration
    By suchetherrah in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-13-2015, 07:52 AM
  3. [SOLVED] Reorder columns from shortest to longest
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-06-2015, 08:22 AM
  4. Macro to select longest column (date period)
    By bryan444 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 12-06-2012, 04:40 AM
  5. Need help calculating the longest streak in a date series
    By SeanMulholland in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2010, 07:13 PM
  6. Longest Time
    By Brento in forum Excel General
    Replies: 1
    Last Post: 10-03-2006, 10:00 AM
  7. Longest Entry in Columns
    By Rebecca in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-26-2005, 12:07 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1