Results 1 to 13 of 13

Calculate Months and Return Last Day

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-02-2012
    Location
    UK
    MS-Off Ver
    365/2008
    Posts
    152

    Calculate Months and Return Last Day

    I'm hoping this is going to be an easy one but not sure if it's at all possible.

    In the attached simplified example, I want to enter a date in A2, enter a number of months in B2. For example, in the attached it shows 14 Apr 14 and 48 months. 48 months from 14 Apr 14 is 14 Apr 18. However, I need C2 to result in the last day of that month, i.e. 30 Apr 18.

    Any help appreciated. (hope I've explained the above clearly).
    Attached Files Attached Files
    Last edited by xybadog; 05-08-2014 at 11:38 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 02-20-2014, 05:46 PM
  2. Using index to return data from list for last 12 months or months available
    By welchs101 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-23-2013, 09:44 AM
  3. Calculate age in months
    By darkobird84 in forum Excel General
    Replies: 1
    Last Post: 03-09-2011, 11:34 AM
  4. Calculate Age in Months
    By Tim Hardison in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-09-2009, 07:42 PM
  5. Calculate 6 Months
    By Jason in forum Excel General
    Replies: 5
    Last Post: 08-18-2005, 08:05 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