Results 1 to 5 of 5

Looking to calculate months

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Microsoft 365
    Posts
    327

    Looking to calculate months

    Hello,
    I have a simple spreadsheet that will calculate rental payments based on any given month for 1 month.
    I'm looking for help that will calculate based on 2 or more payments.

    I'm using this to calculate 1 month - =IF(C2="","",(DATE(YEAR(C2),MONTH(C2)+1,0)))
    C2 would equal the 1st day of the month (11/01/2012), the formula would return 11/30/2012.

    If a customer wants to pay for 2 months, I would change the formula to calculate 2 months.

    I'm trying to get away from having to change the formula when someone wants to pay for more than 1 month.

    See the attached.

    Any ideas?
    Thanx.
    Attached Files Attached Files

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