Results 1 to 4 of 4

Adding months to start date to get end date

Threaded View

  1. #1
    Registered User
    Join Date
    11-21-2006
    Posts
    35

    Adding months to start date to get end date

    I have found several suggestions how to solve a similar problem, but none of them seems to work for me... I know it is no challenge for all you sharp minds, so please help me with the following:

    In G6 I have a start date (01-02-2011)
    In F6 I have a number of months (24)
    In H6 I need a formula to calculate the end date...

    Below is one of the suggestions I found in here - but I cannot get it to work... :-(

    =MIN(date(year(G6);month(G6)+F6+{0,1};DAY(G6)*{1}))

    I use Office 2010...

    Look forward to your help... :-)
    Last edited by Eva_; 01-06-2011 at 09:55 AM.

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