Results 1 to 7 of 7

Creating a formula to populate range of cells between dates based on start and end dates

Threaded View

Rainmain82 Creating a formula to... 07-20-2014, 11:49 AM
martindwilson Re: Creating a formula to... 07-20-2014, 11:58 AM
Rainmain82 Re: Creating a formula to... 07-20-2014, 01:45 PM
Rainmain82 Re: Creating a formula to... 07-20-2014, 01:52 PM
Vikas_Gautam Re: Creating a formula to... 07-20-2014, 12:08 PM
martindwilson Re: Creating a formula to... 07-20-2014, 02:26 PM
Rainmain82 Re: Creating a formula to... 07-20-2014, 07:42 PM
  1. #1
    Registered User
    Join Date
    07-16-2014
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    15

    Exclamation Creating a formula to populate range of cells between dates based on start and end dates

    Hi All,

    A contributor was able to help me with the first part of this formula. However, I noticed the formula doesn't work on a date range beyond 12 months.

    I've re-posted this thread with the hope that I can get an answer to the second part:

    If you refer to the attached excel file you will notice the Project Manager profile is working from the 01/01/2015 to the 28/02/16. The formula in cell F6 however only identifies the months and not years. So rather than equaling 1 year and 2 months it calculates to 2 months. Likewise the formula in cell range G6:V6 doesn't work on a date range of greater than 12 months (highlighted in yellow).

    Can someone help/show me how I can get the formula to work beyond 12 months?

    Many thanks!
    Remon
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need a formula with flexible start and end dates from a range
    By Lax97 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2017, 12:23 PM
  2. [SOLVED] Creating a formula to populate range of cells between dates based on start and end dates
    By Rainmain82 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-18-2014, 07:55 AM
  3. Replies: 12
    Last Post: 03-07-2013, 11:02 PM
  4. Highlighting range of cells based on start and end dates
    By d0gp1l3 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-13-2012, 12:36 PM
  5. Populate row information based on start end dates
    By rdesai7677 in forum Excel General
    Replies: 6
    Last Post: 03-12-2012, 06:41 PM

Tags for this Thread

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