+ Reply to Thread
Results 1 to 2 of 2

Formula for first date paid

  1. #1
    Registered User
    Join Date
    01-31-2014
    Location
    NJ, NJ
    MS-Off Ver
    Excel 2003
    Posts
    12

    Formula for first date paid

    Sample_first date paid.xlsx

    New to this forum so apologizes in advance if the attachment doesn't work.

    I need help coming up with a formula for column B that will return the date each client began paying. B2 should return "8/20/2013"; B3 should return "8/22/2013"; B7 should return "None to Date"

    Each cell (C2:P6) that doesn't have a number showing is marked as zero (i.e., the cell is not blank/empty).

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Formula for first date paid

    Here!

    Put this in B2 and Drag Down

    =IFERROR(INDEX($C$1:$AR$1,MATCH(1,C2:AR2,1)+1),"None to Date")
    Cheers!
    Deep Dave

+ 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. calculating a paid to date for tenants
    By arthur120 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-28-2013, 08:02 AM
  2. Formula for Calculating Paid Time Off for fiscal anniversary date real time
    By 168rockwood in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-07-2012, 04:15 PM
  3. Replies: 5
    Last Post: 06-02-2012, 06:30 AM
  4. To get the Most Recently paid EMI in tune with the current date.
    By e4excel in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-12-2009, 02:37 PM
  5. [SOLVED] Formula that will give the interest paid on a given date...
    By Marcus Fox in forum Excel General
    Replies: 0
    Last Post: 04-20-2006, 02:50 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