Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: calculating defered payments on a given date

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    this is what i have

    column1 - no of installments i.e 10
    column2 - amount per installment i.e. 100
    column3 - payment start date i.e. 15th march 2002
    column4 - last payment date i.e. 15th Dec 2002
    column5 - now()
    column6 - paid to date ????????


    i would like to know how to calculate how much money we have now for account reconcilliation, and (even on a future date) the paid to date column should not read more than 1000

    can anyone help?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    assuming you are in row 1, try

    =MIN(A1*B1,(DATEDIF(C1,E1,"M")+1)*B1)

    you probably had a feeling I was going to say that.
    good luck

    [ This Message was edited by: IML on 2002-03-21 09:06 ]

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thanks, funnily enough i had a datedif statement, but it wasnt stopping.... i'll give it a go

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thankyou, thankyou, thankyou.....it works.... i wish id come here earlier cos ive spent all afternoon on this and now its time to go home

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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