+ Reply to Thread
Results 1 to 2 of 2

Gantt Chart Setup With Different Date Format

  1. #1
    Registered User
    Join Date
    06-12-2018
    Location
    Malaysia
    MS-Off Ver
    365
    Posts
    1

    Post Gantt Chart Setup With Different Date Format

    Dear Gurus,

    Good Day.
    I am building a Gantt Chart in excel using formula to generate the Gantt Chart outcome, but there is one logic in the if formula I could not figure out.

    The logic that I am using is using IF function, compare start date and end date with the date in Gantt Chart header (date starting every first day of the month).
    The problem that I am facing is if I compare the date of the Gantt Chart with the start and end date of the contract, some of the short term contract in the month will not be capture.
    Below is the formula that I wrote:
    IF(OR($T6="Dropped",$T6="Relocated"),"",IF(AND(Gantt Chart header date>=start date,Gantt Chart header date<=end date),$S6,""))

    Would appreciate if any guru can help to sort out a formula that only compare month and year of between the dates.

    Thank you.

    Warmest Regards,
    Eric

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Gantt Chart Setup With Different Date Format

    Maybe you could use:

    … TEXT(date,"yymm")*1 …

    for each of your dates.

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Have the ability to view a daily Gantt chart as a monthly gantt chart
    By adam_d_john in forum Excel General
    Replies: 3
    Last Post: 03-13-2018, 09:11 PM
  2. Conditional format formula needed for time gantt chart
    By broodytood in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2016, 10:34 PM
  3. [SOLVED] Does conditional format apply to bars of a Gantt chart ?
    By adriano.r.marques in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-01-2015, 03:27 PM
  4. [SOLVED] Coupon date gantt chart help
    By FSUMBA97 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-19-2013, 11:52 AM
  5. Using Gantt chart / date subtractions
    By ritabenki in forum Excel General
    Replies: 1
    Last Post: 07-17-2012, 05:24 AM
  6. Excel 2007 : Gantt Chart Date
    By mcalnan1 in forum Excel General
    Replies: 1
    Last Post: 09-09-2010, 06:43 PM
  7. Gantt Chart change of date
    By seanyeap in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-11-2008, 08:51 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