Results 1 to 2 of 2

Thread: Microsoft project formula again

  1. #1
    Join Date
    Feb 2009
    Location
    fareham
    Posts
    7

    Microsoft project formula again

    My project starts on the 5th january 2009, using our own calendar, therfore day 1 is the 5th jan, and to use a base line, day 75 should be 22nd april 2009. I have customised the 'duration10' field, which has been converted from a number field to show days, so that the number 75 in the number field also shows as 75days in duration 10. I have then used a customised start field and tried 2 formulas to work out what day 75 should be, formulas tried were:

    Project start date + Number 20 ( date returned was the 21st march )

    Project start date + Duration 10 ( errors returned )

    Help ???!!!!

  2. #2
    Join Date
    May 2008
    Posts
    945

    Re: Microsoft project formula again

    The [Deliverable Start] and [Deliverable Finish] fields are available fields in the Custom Fields dialog. It's just that they don't show up as available Fields when you click the Field pick list in the Formula dialog. I created a custom Duration field for the Task type, named it Deliverable Start Variance, and manually typed the entire following formula:

    IIf([Deliverable Start] = ProjDateValue("NA"), 0, ProjDateDiff([Deliverable
    Start], [Start], "Standard"))

Similar Threads

  1. MS project formula's syntax and example
    By Amichait in forum Microsoft Project
    Replies: 1
    Last Post: 11-11-2011, 04:40 PM
  2. microsoft project formula question
    By jed100375 in forum Windows Software
    Replies: 1
    Last Post: 01-05-2011, 12:16 PM
  3. MS Project Formula
    By ConfusedProjectUser in forum Microsoft Project
    Replies: 1
    Last Post: 30-04-2011, 03:42 AM
  4. MSP custom field formula to track project progress
    By M0m1 in forum Microsoft Project
    Replies: 1
    Last Post: 30-04-2011, 03:40 AM
  5. Microsoft Project Formula
    By smtamblyn in forum Windows Software
    Replies: 2
    Last Post: 18-02-2009, 02:47 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
  •  
Page generated in 1,713,243,600.38653 seconds with 17 queries