+ Reply to Thread
Results 1 to 2 of 2

calculate payment with first payment due date variable?

  1. #1
    Jody Solbach
    Guest

    calculate payment with first payment due date variable?

    I need to be able to calculate a payment with the ability to input the first
    payment due date as a variable. for example due date would be in 45 dates
    from current date.

  2. #2
    Registered User
    Join Date
    06-08-2005
    Location
    Middletown, CT, USA
    Posts
    30

    Calculate Payment with....

    Jody,
    If the current date is in A1 from a key-in, reference from another cell or using NOW(), then in B2 place =A1+45. This will show a calendar date 45 days after the date shown in A1. Should A1 change, B1 will change accordingly. Be sure the cells are formatted the same from the many Date choices in the Format drop-down.
    I hope I interpreted your problem properly. GeorgeF

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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