+ Reply to Thread
Results 1 to 7 of 7

Require formula to count the latest date and number subsequent dates.

  1. #1
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    Require formula to count the latest date and number subsequent dates.

    Hi I need a formula that will look at a list of dates and names and list the dates in order (the latest would be the most recent and then work backwards).

    I have attached a sheet for reference.

    Cheers in advance

    JD
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,007

    Re: Require formula to count the latest date and number subsequent dates.

    Uk date format I suspect from your location?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Require formula to count the latest date and number subsequent dates.

    If you sort the data, like you want, i get a diffeant answer.

    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    Re: Require formula to count the latest date and number subsequent dates.

    Hi Special K, yes I use the Uk date format.

    Hi oeldere, please see the attached amended sheet, I had made a mistake on the original.

    Cheers

    John
    Attached Files Attached Files

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    7,743

    Re: Require formula to count the latest date and number subsequent dates.

    E3=B3&"_"&COUNTIFS(B$3:B$11,B3,C$3:C$11,">="&C3)
    Please Login or Register  to view this content.
    Try this and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Require formula to count the latest date and number subsequent dates.

    @john dalton

    same problem, so you should define better how you come to the result.

  7. #7
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    Re: Require formula to count the latest date and number subsequent dates.

    Cheers nflsales, top result mate, thaks for everyones input, I willll bear that in mind oeldere for future posts,

    Most appreciated john

+ 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. [SOLVED] Dates require through week number
    By Nisha Dhawan in forum Excel General
    Replies: 4
    Last Post: 04-14-2015, 06:25 AM
  2. [SOLVED] Require a formula to indicate the latest dates in a column
    By john dalton in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-11-2015, 04:16 AM
  3. Count number of times a specific date happens between two dates
    By Interrogo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2015, 10:02 PM
  4. [SOLVED] Count the number of dates between a date range
    By danfullwood in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-15-2015, 04:50 AM
  5. [SOLVED] Require a formula to progressively count the instances and allocate a number to each
    By john dalton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-16-2014, 10:45 AM
  6. Require fromula to count instances of times and dates
    By john dalton in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2014, 06:00 AM
  7. Want to count number of dates greater than a stated date
    By bjorng in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-09-2014, 09:12 PM

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