+ Reply to Thread
Results 1 to 4 of 4

Nesting IF and INT formula for Gantt Chart

  1. #1
    Registered User
    Join Date
    02-29-2020
    Location
    San Francisco
    MS-Off Ver
    2019
    Posts
    4

    Nesting IF and INT formula for Gantt Chart

    Hi,

    I don't know much about formulas in excel and need assistance with creating a formula that can be used in a Gantt Chart. I imagine it's a nested formula. Currently, I'm using the INT formula in F4 cell to find the difference in weeks between two dates; however, I want F4 to remain blank or "N/A" if column E4 is empty (without a date). Please see diagram below for reference.

    Any assistance would be much appreciated.

    Gantt Chart Example.JPG

    Thank you,
    Christina

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    6,473

    Re: Nesting IF and INT formula for Gantt Chart

    =if(e4="","", int(e4-d4)/7))
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    02-29-2020
    Location
    San Francisco
    MS-Off Ver
    2019
    Posts
    4

    Re: Nesting IF and INT formula for Gantt Chart

    Hi Wayne,

    Thanks for your assistance. It came in the nick of time. I'm about to present my draft in 15 mins. The formula is exactly what I was looking for.

    Much appreciation!

    Stay healthy and be well,
    Christina

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    6,473

    Re: Nesting IF and INT formula for Gantt Chart

    you are welcome
    good luck with presentation

+ 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. [SOLVED] Gantt Chart Formula Problem
    By adam_d_john in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2017, 08:14 PM
  3. Gantt Chart Formula
    By Shermaine2010 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-27-2016, 03:29 AM
  4. Replies: 5
    Last Post: 10-04-2012, 07:01 AM
  5. Replies: 0
    Last Post: 07-13-2012, 06:40 PM
  6. Gantt Chart Formula
    By Jon Excel in forum Excel General
    Replies: 1
    Last Post: 04-25-2011, 01:44 PM
  7. formula for gantt chart
    By sanlen in forum Excel General
    Replies: 1
    Last Post: 08-31-2010, 08:53 AM

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