+ Reply to Thread
Results 1 to 2 of 2

Subtract the two latest dates

  1. #1
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Subtract the two latest dates

    I want to automate row 3.
    In row 3 the number of days is calculated by subtracting the last noted date - the last date noted before that date.
    It is a fairly simple question but I cannot figure it out.

    I created an excel file with a small example also calculated the number of days manual

    Hope somebody can help me.

    Much appreciated
    Attached Files Attached Files
    Last edited by keis386; 03-06-2014 at 10:53 AM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,852

    Re: Subtract the two latest dates

    Put this formula in D3 (i.e. just after your first date):

    =IF(D2="","",D2-LOOKUP(9E+99,$A$2:C2))

    You might need to change the commas to semicolons. Then copy the formula across as far as you need to.

    Hope this helps.

    Pete

+ 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] How can I sort the latest dates in a lot of data?
    By Hin135 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-04-2014, 06:57 AM
  2. Replies: 9
    Last Post: 11-28-2013, 05:20 PM
  3. Replies: 7
    Last Post: 05-02-2013, 09:50 PM
  4. Indexing through latest dates to output corresponding data
    By boylers75 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-10-2012, 11:14 AM
  5. [SOLVED] Return latest Date from cell containing several dates?
    By Motox in forum Excel General
    Replies: 2
    Last Post: 09-10-2012, 07:26 AM

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