+ Reply to Thread
Results 1 to 5 of 5

Looking to calculate months

  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

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Looking to calculate months

    Try in E2 and copy down.

    =IF(C2="","",(DATE(YEAR(C2),MONTH(C2)+D2,0)))
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

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

    Re: Looking to calculate months

    Ah crud.....a simple little fix! Thanx man, that works great.

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Looking to calculate months

    You are welcome.

    Thanks for the reb*.

    Simple is best!

  5. #5
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,702

    Re: Looking to calculate months

    You could also use EOMONTH function like this

    =IF(C2="","",EOMONTH(C2,D2-1))
    Audere est facere

+ 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