Results 1 to 15 of 15

Formula Creation Display Text (SOLVED)

Threaded View

  1. #1
    Registered User
    Join Date
    05-16-2015
    Location
    Queensland
    MS-Off Ver
    2010
    Posts
    6

    Formula Creation Display Text (SOLVED)

    I've been assigned a task at work to create a formula on excel

    Column Cell A Column Cell B
    Work Date Commenced: Project Due:
    10/09/2013
    11/12/2008
    11/03/2015
    30/09/2010
    23/07/2009
    19/09/2008
    26/08/2009


    I need to devise a formula so that Column Cell B either displays "Project due" or "Project not yet due", a project is due exactly every 6 months from the work date commenced.

    =IF((TODAY())-A1=6,"Project Due","Project not yet due")

    This is all I have and I'm not sure if I'm on the right track or using the right formula. Creating a formula that describes if its been 6 months since their commencement date is what is getting to me.

    Which formulae would be helpful in creating something to make a result show on excel every 6 months from that commencement date?
    Last edited by jumpingjack139; 05-17-2015 at 12:23 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel file creation dates do not match the windows creation date.
    By alexthapyro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2011, 12:14 PM
  2. Need help with formula creation
    By Starbucks Junkie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2010, 10:20 AM
  3. Formula creation...if possible
    By Kelly C in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-22-2006, 07:15 PM
  4. Formula Creation via Add-in problem
    By Bill Schanks in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2006, 08:10 PM
  5. [SOLVED] IF Function - formula creation
    By emily's excel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2005, 12:20 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