+ Reply to Thread
Results 1 to 3 of 3

How to Find first Date in a range? How to Find last Date in same range?

  1. #1
    Registered User
    Join Date
    03-19-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Smile How to Find first Date in a range? How to Find last Date in same range?

    Hi Everyone,

    How do I find the first and last Dates in a range of 12 columns? So that I can display the START date (first date found) and the FINISH date (last date found) per row? Please see attached screen snip.

    First and Last Dates per row.jpg

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,824

    Re: How to Find first Date in a range? How to Find last Date in same range?

    1. It is always best to attach a file and not a screen shot (see yellow banner at top of page)
    2. When you say "First" and "Last" Dates Does first mean the first date it comes to or the earliest date (same thing for last).
    3. Let's assume you want to see the Earliest and Latest Dates, you should be able to use the min and max formulas, like:
    =MIN(A1:L1)
    =MAX(A1:L1)

    (A1:L1) is whatever the range of the columns you want to compare.

  3. #3
    Registered User
    Join Date
    03-19-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    6
    Hi Greg, understood about Point1. Point 2, earliest date and first date found will be the same thing, same for last date.

    Thanks for the formulas, ill let you know how it works out.
    Rod
    Last edited by AliGW; 06-28-2020 at 12:18 AM. Reason: Please don’t quote unnecessarily!

+ 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. Method FIND, to find a DATE in a hidden range
    By JCabral in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-13-2020, 12:43 PM
  2. [SOLVED] Find the start date from end date and date range and exclude weekends
    By tantcu in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-28-2017, 04:43 AM
  3. [SOLVED] Find rows matching on 3 columns - date range; dollar range; and A or B
    By strassbergere in forum Excel General
    Replies: 0
    Last Post: 06-28-2016, 08:21 PM
  4. [SOLVED] Macro to find user input date range and delete everything outside range
    By sudric in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-13-2015, 11:52 AM
  5. [SOLVED] look-up a date in a range and find the date that is closest todays date
    By VanShark in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2014, 09:46 PM
  6. [SOLVED] find missing date on every group date list based on range and criteria
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2013, 01:26 AM
  7. Replies: 2
    Last Post: 01-04-2012, 09:15 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